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 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to