David Fetter <[EMAIL PROTECTED]> writes:
> On Fri, Nov 02, 2007 at 11:49:38AM -0400, Andrew Dunstan wrote:
>> At the moment I have to write things like:
>> 
>> update tname set foo = bar ...  where foo is null or foo <> bar

> One way I've done this is make RULEs which basically drop non-updating
> "UPDATEs" on the floor.

A BEFORE UPDATE trigger would be better, and probably hardly more
expensive than a wired-in facility (especially if you were willing to
write it in C).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to