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

From Tom Lane
Subject Re: is this my date problem
Date
Msg-id 26742.1065103479@sss.pgh.pa.us
Whole thread Raw
In response to Re: is this my date problem  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: is this my date problem
List pgsql-bugs
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"

but evidently those checks are not in whatever code path to_timestamp
is calling.

            regards, tom lane

pgsql-bugs by date:

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