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

From Pavel Stehule
Subject Re: how to return results from code block
Date
Msg-id CAFj8pRA5ss9zR5ddz4UpeZ9GvkVoXWwarwWPugaM=5Kgku8yyg@mail.gmail.com
Whole thread Raw
In response to how to return results from code block  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: how to return results from code block
Next
From: "Andrus"
Date:
Subject: How to insert record only if primary key does not exist