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

"Otto Blomqvist" <o.blomqvist@secomintl.com> writes:
> 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

In 8.0 I think it'd work to do

select (x).f1, (x).f2, (x).f3 from
(select testpassbyval(1, number1) as x from test) ss;

            regards, tom lane

Ofcourse this works perfectly  !

Thanks a lot Tom !

Just curious, is this (x)-"trick"   in the postgres manual somewhere ? Just
just common SQL guru knowledge ? ;)

/Otto Blomqvist





"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:5852.1112819444@sss.pgh.pa.us...
> "Otto Blomqvist" <o.blomqvist@secomintl.com> writes:
> > 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
>
> In 8.0 I think it'd work to do
>
> select (x).f1, (x).f2, (x).f3 from
> (select testpassbyval(1, number1) as x from test) ss;
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

On Wed, Apr 06, 2005 at 03:31:45PM -0700, Otto Blomqvist wrote:
> 
> Just curious, is this (x)-"trick"   in the postgres manual somewhere ? Just
> just common SQL guru knowledge ? ;)

I think the relevant documentation is "Field Selection" in the
"Value Expressions" section of the "SQL Syntax" chapter.

http://www.postgresql.org/docs/8.0/interactive/sql-expressions.html#AEN1642

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/