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 LOOPRETURN 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
