Re: execute/perform and FOUND

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: execute/perform and FOUND
Date: 2006-09-21 11:32:02
Message-ID: 20060921113202.GD30441@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 21, 2006 at 01:15:46PM +0200, Karsten Hilbert wrote:
> Assuming EXECUTE does not touch FOUND at all the EXECUTE
> part behaves consistently (namely default FOUND=FALSE at the
> beginning and later whatever it was after the PERFORM).
>
> So, what about the PERFORM ? Why does it set FOUND to true?

I beleive that since PERFORM doesn't return anything, it sets the FOUND
variable to at least indicate whether it did something. OTOH EXECUTE
can return something so it doesn't need that.

It's a bit wierd, but I think later versions changed EXECUTE to set
FOUND also, just to be consistant.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2006-09-21 12:23:12 Re: execute/perform and FOUND
Previous Message Karsten Hilbert 2006-09-21 11:19:41 Re: execute/perform and FOUND