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.
Oops that should have been: raise notice 'The results are %,%', rec.res1,rec.res2 -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
