Re: ERROR: query has no destination for result data

[Peter Kroon <plakroon@xxxxxxxxx>]

When using:

RETURN QUERY(

SELECT 'this is text'

);

I get another error: 

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

2012/11/23 Craig Ringer <craig@xxxxxxxxxxxxxxx>

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

Hello,

I wish to return the SELECT statement.

Ho can I achieve this?

RETURN QUERY.

See http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html

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