Omar Bettin wrote:
Hi,
I have to compare an OLD.Value with a NEW.Value on PostgreSQL 8.2.4
plpgsql trigger function:
IF OLD.Value <> NEW.Value THEN
...
but, if OLD.Value IS NULL and NOT NEW.Value IS NULL the previous IF
does not work and I have to use this method:
IF (OLD.Value <> NEW.Value) OR (OLD.Value IS NULL AND NOT NEW.Value
IS NULL) THEN
...
this works!
Is that normal ?
Please do not ask usage questions on the -hackers list. This should have
been asked on the pgsql-general list.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
