X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 27E8DD1D61F for ; Tue, 2 Dec 2003 10:36:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 91460-04 for ; Tue, 2 Dec 2003 06:36:23 -0400 (AST) Received: from dyatel.antar.bryansk.ru (unknown [195.239.214.85]) by svr1.postgresql.org (Postfix) with ESMTP id F114AD1C96D for ; Tue, 2 Dec 2003 06:36:19 -0400 (AST) Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.24; FreeBSD) id 1AR7t9-0007l5-5E; Tue, 02 Dec 2003 13:36:15 +0300 Date: Tue, 2 Dec 2003 13:36:15 +0300 From: "Alexander M. Pravking" To: Karel Zak Cc: Christoph Haller , pgsql-sql@postgresql.org Subject: Re: Validity check in to_date? Message-ID: <20031202103615.GH87728@dyatel.antar.bryansk.ru> References: <20031127141125.GC87728@dyatel.antar.bryansk.ru> <200312020927.KAA17321@rodos> <20031202095713.GB17884@zf.jcu.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <20031202095713.GB17884@zf.jcu.cz> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/14 X-Sequence-Number: 16180 On Tue, Dec 02, 2003 at 10:57:14AM +0100, Karel Zak wrote: > > > If not, has something changed in 7.4? > > No change in 7.4. Maybe in 7.5 or in some 7.4.x. Well, let's see. > The others PostgreSQL stuff which full parse (means check ranges) > date/time is less optimistic with this: > > # select '31.11.2003'::date; > ERROR: date/time field value out of range: "31.11.2003" Exactly! But date_in formats are too limited and "floaty", especially in 7.3 or less. -- Fduch M. Pravking