> 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
SQL-standard.
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.
Harald
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
