Viktor
The quick and dirty method would be to pass the subquery as a string,
then execute the subquery in the function.
Will T
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> -Original Message-
> From: Viktor Rosenfeld [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 28, 2008 4:52 PM
> To: Roberts, Jon
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] passing a temporary table with more than one
column
> to a stored procedure
Hi Jon,
Am 28.04.2008 um 19:23 schrieb Roberts, Jon:
What does the signature of graphovertokens look like? Three
parmaters
and it doesn't return a setof?
This is my problem. The return type is setof something (doesn't
really matter), but I don't know what to put into the argument list.
> 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_re
Hi,
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
