Re: ERROR: query has no destination for result data

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