Hello 2012/6/30 Andrus <kobrule...@hot.ee>: > 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 ?
you cannot return any result from block - block is similar to void function Regards Pavel > > Andrus. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
