Neil Conway <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Yeah, this has been on my to-do list for awhile...
> Ah, ok. Is this something you want to handle, or should I take a look?
Well, it's not *high* on my to-do list; feel free to take a look.
>> One question here is whether Oracle's PL/SQL has a
>> precedent, and if so which way does it point?
> I did some limited testing of this, and it appears that PL/SQL's EXECUTE
> IMMEDIATE modifies SQL%FOUND.
Hm, okay, then we should probably think about doing so too.
If the EXECUTE executes something that's not
SELECT/INSERT/UPDATE/DELETE, should it clear FOUND? Or leave it alone?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
