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(at)2ndquadrant(dot)com>
> 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<http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html>
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>