Re: ERROR: query has no destination for result data

[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