> is there a way to pass a temporary result table with more than column > to a stored procedure? > > Specifically, I would like to run a variation of this query: > > SELECT > * > FROM > graphOverTokens( > ( > SELECT 1 AS min, 10 AS max, 2 AS text_ref > UNTION SELECT 20 AS min, 30 AS max, 3 AS text_ref > ) AS boundaries > JOIN struct ON (struct.text_ref = boundaries.text_ref) > JOIN rank ON (rank.struct_ref = struct.id) > ) AS graph > What does the signature of graphovertokens look like? Three parmaters and it doesn't return a setof? select graphovertokens(graph.min, graph.max, graph.text_ref), * from ( ( SELECT 1 AS min, 10 AS max, 2 AS text_ref UNTION SELECT 20 AS min, 30 AS max, 3 AS text_ref ) AS boundaries JOIN struct ON (struct.text_ref = boundaries.text_ref) JOIN rank ON (rank.struct_ref = struct.id) ) AS graph Jon
