--- Jon Collette <[EMAIL PROTECTED]> wrote: > Thanks that was it exactly. I did notice another strange thing. When > using IS NULL in an plpgsql IF statement you have to use ISNULL. Same > with NOT NULL. Does this mean that ISNULL is more proper than IS NULL?
Good question, I am not sure about the proper syntax for plpgsql. However, IS NULL is correct for sql statements. Also, don't forget to cc. the list so that other can chime in as well. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
