Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A58AB9F947A for ; Wed, 15 Aug 2007 18:48:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 81493-10 for ; Wed, 15 Aug 2007 18:48:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 87A6D9F927F for ; Wed, 15 Aug 2007 18:48:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7FLmJFU007679; Wed, 15 Aug 2007 17:48:19 -0400 (EDT) To: Richard Broersma Jr cc: Jon Collette , SQL Postgresql List Subject: Re: Boolean without default declared In-reply-to: <989922.97997.qm@web31811.mail.mud.yahoo.com> References: <989922.97997.qm@web31811.mail.mud.yahoo.com> Comments: In-reply-to Richard Broersma Jr message dated "Wed, 15 Aug 2007 12:36:14 -0700" Date: Wed, 15 Aug 2007 17:48:19 -0400 Message-ID: <7678.1187214499@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/137 X-Sequence-Number: 29075 Richard Broersma Jr writes: > --- Jon Collette 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? IS NULL is in the SQL standard, the other is not; and I dunno what you did wrong but you certainly don't "have to" use ISNULL in plpgsql. regards, tom lane