On December 20, 2005 10:52 am, Jaime Casanova wrote: > have you tried? Yes:
=> SELECT my_func('Sample', NULL, SELECT MIN(year) FROM audio);
ERROR: syntax error at or near "SELECT" at character 32
PostgreSQL 7.4.9, myfunc is pl/pgsql.
Just found a working method, though:
=> SELECT my_func('Sample', NULL, MIN(year)) FROM audio [ WHERE ... ];
--
Michael Burke
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
