On Wed, Sep 28, 2011 at 11:43 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Henk Enting" <h(dot)d(dot)enting(at)mgrid(dot)net> writes:
>> I would expect the to_timestamp function to return an error when I feed it
>> out of range values, e.g. months > 13 and days > 31. Instead it seems to add
>> the surplus to the timestamp and then return it.
> What is your reason for using to_timestamp at all? The timestamp input
> converter is perfectly capable of dealing with standard formats like
> yyyy-mm-dd, and it does what most people expect in the way of data
> validation checks.
Well, you might want to insist that the input is in some particular
format, rather than just "whatever the input function will accept"...
The Enterprise PostgreSQL Company
In response to
pgsql-bugs by date
|Next:||From: Peter Geoghegan||Date: 2011-09-29 20:26:36|
|Subject: "no relation entry for relid 1"|
|Previous:||From: Christopher Browne||Date: 2011-09-29 12:26:06|
|Subject: Re: PostGre compatible to RHEL 6.1|