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 56850545E9 for ; Fri, 18 Mar 2005 09:10:14 +0000 (GMT) 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 61945-02 for ; Fri, 18 Mar 2005 09:10:13 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8872752A59 for ; Fri, 18 Mar 2005 09:10:11 +0000 (GMT) Received: (qmail 23014 invoked from network); 18 Mar 2005 10:10:18 +0100 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 18 Mar 2005 10:10:18 +0100 To: =?iso-8859-15?Q?Ragnar_Hafsta=F0?= , "Kenneth Gonsalves" Cc: "Richard Huxton" , weberp@paradise.net.nz, pgsql-sql@postgresql.org Subject: Re: Query performance problem References: <200503172120.20676.weberp@paradise.net.nz> <1111131172.25405.17.camel@localhost.localdomain> <200503181049.47566.lawgon@thenilgiris.com> <42398EB9.2050707@archonet.com> <200503171801.19412.lawgon@thenilgiris.com> Message-ID: Date: Fri, 18 Mar 2005 10:10:10 +0100 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <1111131172.25405.17.camel@localhost.localdomain> User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/257 X-Sequence-Number: 20736 > DEFAULT applies to INSERTs, NOT NULL applies to UPDATEs too. In MySQL it applies to both (ie. if you UPDATE to an invalid value, it sets it to 'something'). NOT NULL without default is useful when you want to be sure you'll never forget to put a value in that column, when there is no meaningful default. Also for foreign keys : what would be the default value of a foreign key ? > > gnari > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >