Re: [SQL] Problems with Set Returning Functions (SRFs)

[Sean Davis <sdavis2@xxxxxxxxxxxx>]

On Apr 6, 2005, at 2:53 PM, Otto Blomqvist wrote:
> secom=# select f1, f2, f3 from testpassbyval(1, (Select number1 from 
> test));
> ERROR:  more than one row returned by a subquery used as an expression
>
> This is where I fail. Am I even on the right path here ? Writing the 
> actual
> parsing function will be easy once I have a working concept.

How about (untested):

select f1, f2, f3 from (
	select testpassbyval(1,(
		select number1 from test)
	                    )
	) a;

Sean


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings