> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
