Re: Some notes about Param handling with "Oracle style" plpgsql variables - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Some notes about Param handling with "Oracle style" plpgsql variables
Date
Msg-id 603c8f070911020942k555a970btd03fa02502deb6c3@mail.gmail.com
Whole thread Raw
In response to Some notes about Param handling with "Oracle style" plpgsql variables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Some notes about Param handling with "Oracle style" plpgsql variables
List pgsql-hackers
On Mon, Nov 2, 2009 at 11:31 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>  Another interesting property
> of this approach is that it'd fix the longstanding user complaint
> that constructions like
>        if (TG_OP = 'INSERT' and NEW.foo = 'bar') ...
> fail prematurely.  The executor would never demand the value
> of NEW.foo, and thus not fail, if TG_OP isn't INSERT.

I don't really know enough to comment on the best way to go about this
project overall, but fixing this would be incredibly nice, if it can
be done without too much damage.

...Robert


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: per-tablespace random_page_cost/seq_page_cost
Next
From: Jeff Davis
Date:
Subject: Re: operator exclusion constraints