| From: | "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Validity check in to_date? |
| Date: | 2003-12-02 10:36:15 |
| Message-ID: | 20031202103615.GH87728@dyatel.antar.bryansk.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iain | 2003-12-02 10:44:54 | Re: Validity check in to_date? |
| Previous Message | Alexander M. Pravking | 2003-12-02 10:30:59 | Re: Validity check in to_date? |