Re: ERROR: query has no destination for result data

[Peter Kroon <plakroon@xxxxxxxxx>]

When using plain SQL I get this message:

ERROR:  language "sql" does not support inline code execution

When removing the BEGIN+END block statements the message persists.

2012/11/23 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