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