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 <cr...@2ndquadrant.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 > >
