Re: Empty Updates, ON UPDATE triggers and Rules

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Empty Updates, ON UPDATE triggers and Rules
Date: 2009-08-06 17:38:37
Message-ID: 1249580317.9256.768.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2009-08-06 at 13:15 -0400, Merlin Moncure wrote:
> in 8.4 you can (and should) do:
> WHERE old = new

I couldn't get that to work in a rule.

> IF NEW != OLD THEN -- 8.4 syntax

Does this work correctly in the case of NULLs? It looks like it does,
but that seems strange, because ROW(1, NULL) = ROW(1, NULL) evaluates to
NULL. Where is this documented?

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message decibel 2009-08-06 17:39:17 Re: Constraint between 2 tables and taking a coherent snapshot of both
Previous Message Jeff Davis 2009-08-06 17:17:23 Re: Empty Updates, ON UPDATE triggers and Rules