Re: ERROR: query has no destination for result data

[Craig Ringer <craig@xxxxxxxxxxxxxxx>]

On 11/23/2012 06:53 PM, Peter Kroon wrote:

When using:

RETURN QUERY(

SELECT 'this is text'

);

I get another error: 

ERROR:  cannot use RETURN QUERY in a non-SETOF function

Use a plain SQL function instead of PL/PgSQL, or use `SELECT INTO` and ordinary `RETURN`.

-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services