Home > mailing lists

how to return results from code block - Mailing list pgsql-general

From	Andrus
Subject	how to return results from code block
Date	June 30, 2012 10:18:15
Msg-id	F3F399315EEE46CDA62F7899C2805C8E@dell2 Whole thread Raw
Responses	Re: how to return results from code block Re: how to return results from code block Re: how to return results from code block Re: how to return results from code block
List	pgsql-general

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.

From: tuanhoanganh
Date: 30 June 2012, 09:42:43
Subject: Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute

From: Pavel Stehule
Date: 30 June 2012, 10:27:33
Subject: Re: how to return results from code block