Adrian Klaver wrote:
Did you happen to catch this:
Note that functions using RETURN NEXT or RETURN QUERY must be called as a table
source in a FROM clause
Try:
select * from test_function(1)
I did miss that, but using that method to query the function
didn't work either. Postgres doesn't see the result as a
tabular set of records.
Even if I replace the FOR loop with:
<quote>
FOR R IN SELECT * FROM pg_database LOOP
RETURN NEXT R;
END LOOP;
</quote>
I get the same error(s). I don't think postgres likes
the unrelated 'SELECT INTO <variable> [column] FROM [QUERY] LIMIT 1'
lines before the FOR loop...
I think I need to go back and approach the function from a
different direction.
Thanks for all the pointers.
Peter
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
