Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> writes:
> to_date() doesn't check the date range, which results in unreadable
> data like this.
> foo=# create table t as select to_date('9999-12-10 BC', 'YYYY-MM-DD
> SELECT 1
> foo=# table t;
> ERROR: timestamp out of range
> Attached is to add IS_VALID_JULIAN() as we do like in date_in(). I
> think to_date() should follow it because it is the entrance place to
> check sanity.
This looks like a good idea, will commit.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Greg Smith||Date: 2013-01-14 20:37:40|
|Subject: Re: Timing events WIP v1|
|Previous:||From: David Johnston||Date: 2013-01-14 20:09:59|
|Subject: Re: count(*) of zero rows returns 1|