On 11/23/12 2:53 AM, Peter Kroon wrote:
> I get another error:
> ERROR: cannot use RETURN QUERY in a non-SETOF function
>
what is your function deined to return?
a query returns a set of records, even if that set is 1 record of 1
field (like, select 'some text';)
you could declare a record variable, and use SELECT ... INTO myrecordvar
[FROM ...];
http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW
then return a field of that record variable.
see this example...
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING
... for how you would loop through query results
--
john r pierce N 37, W 122
santa cruz ca mid-left coast