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:
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.
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