From: Alexander M. Pravking <fduch@antar.bryansk.ru>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Validity check in to_date?
Date: Tue, 2 Dec 2003 13:36:15 +0300
Message-ID: <20031202103615.GH87728@dyatel.antar.bryansk.ru> (raw)
In-Reply-To: <20031202095713.GB17884@zf.jcu.cz>
References: <20031127141125.GC87728@dyatel.antar.bryansk.ru>
<200312020927.KAA17321@rodos>
<20031202095713.GB17884@zf.jcu.cz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fduch@antar.bryansk.ru, zakkr@zf.jcu.cz, ch@rodos.fzk.de
Subject: Re: Validity check in to_date?
In-Reply-To: <20031202103615.GH87728@dyatel.antar.bryansk.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox