X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B6953D1BABF for ; Thu, 24 Jun 2004 16:27:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59222-05 for ; Thu, 24 Jun 2004 19:27:19 +0000 (GMT) Received: from fep02-mail.bloor.is.net.cable.rogers.com (fep02-mail.bloor.is.net.cable.rogers.com [66.185.86.72]) by svr1.postgresql.org (Postfix) with ESMTP id 1E2C1D1BAA5 for ; Thu, 24 Jun 2004 16:27:14 -0300 (ADT) Received: from phlogiston.dydns.org ([65.49.125.184]) by fep02-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040624192522.TUXX41217.fep02-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Thu, 24 Jun 2004 15:25:22 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 1CEF23C28; Thu, 24 Jun 2004 15:27:14 -0400 (EDT) Date: Thu, 24 Jun 2004 15:27:14 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: feature request ? Message-ID: <20040624192714.GA30676@phlogiston.dyndns.org> Mail-Followup-To: pgsql-sql@postgresql.org References: <6C87495E-C5F6-11D8-B2C1-000A95C88220@myrealbox.com> <20040624173259.65980.qmail@web50006.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040624173259.65980.qmail@web50006.mail.yahoo.com> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep02-mail.bloor.is.net.cable.rogers.com from [65.49.125.184] using ID at Thu, 24 Jun 2004 15:25:22 -0400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/241 X-Sequence-Number: 18186 On Thu, Jun 24, 2004 at 12:32:59PM -0500, Jaime Casanova wrote: > > Why not disallow the ability of boolean fields to be null? Why not do it yourself? That's what the NOT NULL constraint is for. A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin