Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL PERFORM with CTE - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PL/pgSQL PERFORM with CTE
Date
Msg-id CAFj8pRCBGCA8jc7AigF7W4=4Sm2MR28PFXPtmOTCZeDmhRedvA@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL PERFORM with CTE  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers
Tree view



2013/8/20 David E. Wheeler <david@justatheory.com>
On Aug 20, 2013, at 3:38 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

> pg_notify returns void, so there are no necessary casting to void
>
> so enhanced check - so all returned columns are void should be enough

What if I call another function I wrote myself that returns an INT, but I do not care about the INT? Maybe that function does the insert and returns the number of inserted rows.

I can think of all kinds of reasons this might be the case; whether they are good or bad approaches is immaterial: sometimes you work with what you have.

I am find with PERFORM to determine when a query's results should be discarded. I just think it needs to cover a few more cases.

yes

I understand. I'll look, how PERFORM can be fixed

Regards

Pavel
 

Best,

David

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: PL/pgSQL PERFORM with CTE
Next
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])