From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature? |
Date: | 2010-09-16 14:23:09 |
Message-ID: | AANLkTimhhwSiytozS4M76HAicGeG0rYBg8hwvu6pWh-W@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/9/16 Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org>:
> On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
>> Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org> writes:
>> > I noticed that in a pl/pgsql function FOUND is not set after an
>> > EXECUTE ... into var;
>> > Bug or feature?
>>
>> It's behaving as documented:
>> http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
>>
>> Adding EXECUTE to the list of statements that change FOUND would have a
>> rather large risk of breaking existing plpgsql functions, IMO.
>
> but is really surprising and non-intuitive, given that 'return query
> execute' does.
RETURN QUERY EXECUTE is a new statement. And it has not original in
PL/SQL so there are not reason to copy misfeature from Oracle.
Regards
Pavel Stehule
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-16 14:54:24 | Re: missing chunk number 497 for toast value 504723663 |
Previous Message | Louis-David Mitterrand | 2010-09-16 14:15:24 | Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature? |