Re: how to return results from code block

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(dot)klaver(at)gmail(dot)com