On 06/30/2012 03:17 AM, Andrus wrote:
How to return single row or results from code block executed using
ADO.NET ExecuteQuery() method.
I tried
DO $$
declare
i integer :=0;
begin
select i+1 as res1, i+2 as res2;
END$$;
but got error:
ERROR: query has no destination for result data
How to return single row result from code pgsql code block ?
Andrus.
Besides what Pavel said about not returning a result there is another
issue with the above. It did not specify a language. I cleaned the
function up a bit:
DO $$
declare
i integer :=0;
rec record;
begin
select i+1 as res1, i+2 as res2 into rec;
raise notice 'The results are %s,%s', rec.res1,rec.res2;
END$$ LANGUAGE plpgsql;
This does not actually return anything but does raise a notice so you
see something happened.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
