Re: is this my date problem - Mailing list pgsql-bugs

From Karel Zak
Subject Re: is this my date problem
Date
Msg-id 20031002144250.GA13041@zf.jcu.cz
Whole thread Raw
In response to Re: is this my date problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, Oct 02, 2003 at 10:04:39AM -0400, Tom Lane wrote:
> Karel Zak <zakkr@zf.jcu.cz> writes:
> >  The to_timestamp() do nothing with date/time and use internal
> >  tm2timestamp() routine only. I don't think that check all date/time
> >  ranges in to_timestamp() is good idea if it's already implemented at
> >  the another place in our code.
>
> But it evidently *isn't* checked.  As of CVS tip:
>
> regression=# select to_timestamp('44 October 2003', 'DD FMMonth YYYY');
>       to_timestamp
> ------------------------
>  2003-11-13 00:00:00-05
> (1 row)
>
> The regular timestamp input converter certainly has the checks:
>
> regression=# select '44 October 2003'::timestamp;
> ERROR:  invalid input syntax for type timestamp: "44 October 2003"

 Sure, because it check date/time parsers and there isn't common way
 how check it if you don't use there parses.

 OK, I will add 'tm' struct checker to my TODO for 7.5

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: is this my date problem
Next
From: Tom Lane
Date:
Subject: Re: 7.3.4: memory leak in fe-exec.c:279 (realloc)