Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7E0AB475D55 for ; Tue, 25 Jun 2002 20:55:03 -0400 (EDT) Mailbox-Line: From beth@vizxlabs.com Tue Jun 25 20:55:03 2002 Received: from lsh114.siteprotect.com (lsh114.siteprotect.com [66.113.130.247]) by postgresql.org (Postfix) with ESMTP id 8EAA147643C for ; Tue, 25 Jun 2002 20:52:35 -0400 (EDT) Received: from bethvizx (ns2.vizxlabs.org [216.122.78.42]) by lsh114.siteprotect.com (8.9.3/8.9.3) with ESMTP id TAA06688 for ; Tue, 25 Jun 2002 19:52:39 -0500 From: "Beth Gatewood" To: Subject: what is the difference between default 0 vs default '0' Date: Tue, 25 Jun 2002 17:52:34 -0700 Message-ID: <000c01c21cab$c2f35ef0$6901a8c0@bethvizx> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Importance: Normal X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/341 X-Sequence-Number: 8306 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