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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Otto Blomqvist" <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
