Re: [BUGS] INSTEAD rule bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 29000.1058290254@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> The problem is that in the 'real life' situation the condition is a lot
> more complicated than this simple is null test... I hate having to
> duplicate it, and I hate even more having to evaluate it twice on every
> insert :-(

Why evaluate it twice?  The DO INSTEAD NOTHING rule should be
unconditional.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jay O'Connor"
Date:
Subject: Re: perfromance impact of vacuum
Next
From: Dmitry Tkach
Date:
Subject: Re: [BUGS] INSTEAD rule bug?