> ON UPDATE TO album WHERE new.pls_id != old.pls_id
> It works until new.pls_id or old.pls_id is null. The rule is still called
> (based on my test), but the "DO" query is not executed correctly. The
> values in "album_edit" are not updated.
To compare "NULL" to something is allways a bad idea. The behaviour in
Postgres is exactly as documented and specified within the
BUT... that is quite different from what you would expect.
To test on "NULL" values within SQL only "is null" is helpfull.
I would strongly recommend to you to read the appropriate chapters
about Null-Values. It seems strange at first but managable.
In response to
pgsql-bugs by date
|Next:||From: Harald Armin Massa||Date: 2004-10-24 10:17:01|
|Subject: Re: select() failed in statistics collector|
|Previous:||From: Harald Armin Massa||Date: 2004-10-24 10:07:00|
|Subject: Re: Beta3 much slower than Beta2|