Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DFDDE9F9768 for ; Wed, 15 Aug 2007 16:36:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 57183-07 for ; Wed, 15 Aug 2007 16:36:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31811.mail.mud.yahoo.com (web31811.mail.mud.yahoo.com [68.142.207.74]) by postgresql.org (Postfix) with SMTP id 3CF499F9735 for ; Wed, 15 Aug 2007 16:36:20 -0300 (ADT) Received: (qmail 98461 invoked by uid 60001); 15 Aug 2007 19:36:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=SJvgfKZKWwqyoFIX2116CtqSRfJyelAG6kB/Yhenmzx20FLfXD59gkHqYWACTr/hoOUTNH5m3ox3WLK7aX1RwA0tqCLIMrwpEeK6nuDxqamvDPqUsS50zJteWTDS7pPAA4m3fMMfOQTNTGvKaKQoMpKyf713BcXZ5ovaTyjcA+4=; X-YMail-OSG: LeO_B5QVM1nM_BYMpnPNsnSJwg5us7mIPrlkT6pAqQDR4L4O4290OAkQN2VpQ3HlJSqNuOxlgA-- Received: from [12.180.237.138] by web31811.mail.mud.yahoo.com via HTTP; Wed, 15 Aug 2007 12:36:14 PDT Date: Wed, 15 Aug 2007 12:36:14 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Boolean without default declared To: Jon Collette Cc: SQL Postgresql List In-Reply-To: <46C35421.8010801@etelos.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <989922.97997.qm@web31811.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/131 X-Sequence-Number: 29069 --- 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? 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.