Re: [GENERAL] Trigger help - updates to column data with null values

2010-03-02 Thread Greg Fischer
NICE!!! Worked beautifully! I figured NULL's were not evaluating as a value, but I didn't have the correct operators: these constructs effectively act as though null were a normal data value, > rather than “unknown”. I guess I wasn't reading the right part of the manuals! LOL! Thanks so much!

Re: [GENERAL] Trigger help - updates to column data with null values

2010-03-02 Thread Craig Ringer
Greg Fischer wrote: > Hello all! > I do my best to read and google my way around issues, but I seem to be > missing something. Probably simple too. > > So I have a trigger function, in which I'd like to check if a particular > column has changed. It works great, unless either the OLD or NEW value

[GENERAL] Trigger help - updates to column data with null values

2010-03-02 Thread Greg Fischer
Hello all! I do my best to read and google my way around issues, but I seem to be missing something. Probably simple too. So I have a trigger function, in which I'd like to check if a particular column has changed. It works great, unless either the OLD or NEW values are NULL. The purpose is to c