Yes, but this means I have to create a function which is something I don't want. I just want to debug some of my code in the related function. So what I want is in pgAdmin declare some vars and run the sql and get the result.
2012/11/23 John R Pierce <pie...@hogranch.com> > On 11/23/12 2:53 AM, Peter Kroon wrote: > >> I get another error: >> ERROR: cannot use RETURN QUERY in a non-SETOF function >> >> > what is your function deined to return? > > a query returns a set of records, even if that set is 1 record of 1 field > (like, select 'some text';) > > you could declare a record variable, and use SELECT ... INTO myrecordvar > [FROM ...]; > http://www.postgresql.org/**docs/current/static/plpgsql-** > statements.html#PLPGSQL-**STATEMENTS-SQL-ONEROW<http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW> > then return a field of that record variable. > > see this example... > http://www.postgresql.org/**docs/current/static/plpgsql-** > control-structures.html#**PLPGSQL-RECORDS-ITERATING<http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING> > ... for how you would loop through query results > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
