Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7896B475E0B for ; Wed, 26 Jun 2002 02:51:09 -0400 (EDT) Mailbox-Line: From chriskl@familyhealth.com.au Wed Jun 26 02:51:09 2002 Received: from mail.iinet.net.au (symphony-03.iinet.net.au [203.59.3.35]) by postgresql.org (Postfix) with SMTP id 4DC50475469 for ; Wed, 26 Jun 2002 02:50:21 -0400 (EDT) Received: (qmail 20268 invoked by uid 666); 26 Jun 2002 06:50:18 -0000 Received: from unknown (HELO SOL) (203.59.111.167) by mail.iinet.net.au with SMTP; 26 Jun 2002 06:50:18 -0000 Message-ID: <020601c21cdd$36128a10$0200a8c0@SOL> From: "Christopher Kings-Lynne" To: "Beth Gatewood" , References: <000c01c21cab$c2f35ef0$6901a8c0@bethvizx> Subject: Re: what is the difference between default 0 vs default '0' Date: Wed, 26 Jun 2002 14:46:32 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Spam-Status: No, hits=1.0 required=5.0 tests=RCVD_IN_MULTIHOP_DSBL,X_RCVD_IN_UNCONFIRMED_DSBL, FUDGE_MULTIHOP_RELAY version=2.30 X-Spam-Level: * X-Archive-Number: 200206/342 X-Sequence-Number: 8307 Hi Beth, I wouldn't have thought there'd be any difference to you, the user. If you used 0, then that is an integer and that will be the default. If you used '0' then that is a character or string and it will automatically be cast into an integer when used as a default. Chris ----- Original Message ----- From: "Beth Gatewood" To: Sent: Wednesday, June 26, 2002 8:52 AM Subject: [SQL] what is the difference between default 0 vs default '0' > all- > Could somebody tell me why I would use default 0 vs default '0' in the > following.... > CREATE TABLE foo (col1 INTEGER default 0) <-- or default '0' > > Thanks- > Beth > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >