Re: Boolean without default declared

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Jon Collette <jon(at)etelos(dot)com>
Cc: SQL Postgresql List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Boolean without default declared
Date: 2007-08-15 19:36:14
Message-ID: 989922.97997.qm@web31811.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


--- Jon Collette <jon(at)etelos(dot)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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Diehl 2007-08-15 20:28:17 Problem with phone list.
Previous Message Richard Broersma Jr 2007-08-15 19:23:58 Re: Boolean without default declared