Hello
2012/6/30 Andrus <kobruleht2@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.