Re: Boolean without default declared - Mailing list pgsql-sql

--- Jon Collette <jon@etelos.com> 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.