Re: passing a temporary table with more than one column to a stored procedure - Mailing list pgsql-general

> 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