X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B6FADA108 for ; Thu, 6 Oct 2005 14:56:10 -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 98584-06 for ; Thu, 6 Oct 2005 17:56:07 +0000 (GMT) Received: from pobox.globalherald.net (pobox.bitbuckets.com [192.122.208.6]) by svr1.postgresql.org (Postfix) with ESMTP id 5A601DA0E2 for ; Thu, 6 Oct 2005 14:56:08 -0300 (ADT) Received: from pobox.bitbuckets.com (pobox.bitbuckets.com [192.122.208.6]) by pobox.globalherald.net (Postfix) with ESMTP id 2A6BF1C280 for ; Thu, 6 Oct 2005 09:01:22 -0400 (EDT) Date: Thu, 6 Oct 2005 09:01:22 -0400 (EDT) From: Joshua Kramer X-X-Sender: josh@localhost.localdomain To: pgsql-sql@postgresql.org Subject: DATESTYLE and 0000-00-00 Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.614 required=5 tests=[AWL=0.564, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/59 X-Sequence-Number: 22912 Greetings, I have my DATESTYLE set to ISO MDY. When I try to create a table with a default date of 0000-00-00, psql says that this is an invalid date. Why, and can (or how can I) get it to accept 0000-00-00 as a valid date? Thanks, -Josh