Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7AB14475A7D for ; Tue, 25 Jun 2002 22:39:36 -0400 (EDT) Mailbox-Line: From missive@frontiernet.net Tue Jun 25 22:39:36 2002 Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 289A7475C5D for ; Tue, 25 Jun 2002 22:36:04 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id A0D92381C87; Tue, 25 Jun 2002 22:35:28 -0400 (EDT) From: Lee Harr X-Newsgroups: comp.databases.postgresql.sql Subject: Re: what is the difference between default 0 vs default '0' Date: Wed, 26 Jun 2002 02:35:28 +0000 (UTC) Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 13 Message-ID: References: <000c01c21cab$c2f35ef0$6901a8c0@bethvizx> Reply-To: missive@hotmail.com X-Complaints-To: news@hub.org User-Agent: slrn/0.9.7.3 (FreeBSD) To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/347 X-Sequence-Number: 8312 In article <000c01c21cab$c2f35ef0$6901a8c0@bethvizx>, "Beth Gatewood" wrote: > 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' > 0 is an integer '0' is a string default '0' might work (through type coercion) but I think default 0 is more clear.