"Otto Blomqvist" <o.blomqvist@xxxxxxxxxxxxx> 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly