Re: ERROR: query has no destination for result data - Mailing list pgsql-general

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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general