2009/6/24 Jeremy Ford <jeremford(at)gmail(dot)com>:
> I've just compiled and run the 8.4.RC2 code. For both of the following
> queries I get "0009-03-01"
> SELECT to_date(' 2009 03', ' YYYY MM') as extraspace; --returns
> SELECT to_date('2009 03', ' YYYY MM') as bogusspace; --returns "0009-03-01"
> Was it the intention to imitate Oracle behavior for these two cases in this
> release? (8.3.7 returns "0009-03-01" as well)
I think, at this stage (so close to release) we're just trying to keep
up a reasonable compatibility with 8.3 and earlier. The fact that the
"bogus space" case doesn't match the Oracle behaviour might be fertile
ground for future improvement in the 8.5 cycle.
Thanks for testing!
In response to
pgsql-hackers by date
|Next:||From: Boszormenyi Zoltan||Date: 2009-06-24 09:51:57|
|Subject: ECPG dynamic cursor, SQLDA support|
|Previous:||From: Dimitri Fontaine||Date: 2009-06-24 07:59:28|
|Subject: Re: Extensions User Design|
pgsql-bugs by date
|Next:||From: Richard Tector||Date: 2009-06-24 10:21:13|
|Subject: BUG #4877: LDAP auth allows empty password string|
|Previous:||From: Bhushan Verma||Date: 2009-06-24 09:30:00|
|Subject: Re: psql: FATAL: the database system is in recovery mode|