Re: FUNCTION problem

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