Clean up the code for to_timestamp's conversion of year plus ISO day number
to date, as per bug #4702 and subsequent discussion. In particular, make it
work for years specified using AD/BC or CC fields, and fix the test for "no
year specified" so that it doesn't trigger inappropriately for 1 BC (which it
was doing even in code paths that had nothing to do with to_timestamp). I
also did some minor code beautification in the non-ISO-day-number code path.
This area has been busted all along, but because the code has been rewritten
repeatedly, it would be considerable trouble to back-patch. It's such a
corner case that it doesn't seem worth the effort.
formatting.c (r1.155 -> r1.156)
timestamp.c (r1.196 -> r1.197)
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2009-03-15 22:05:17|
|Subject: pgsql: Fix contrib/hstore to throw an error for keys or values that |
|Previous:||From: User Andrewsn||Date: 2009-03-15 16:54:42|
|Subject: uuid-freebsd - uuid-freebsd: for v1mc, randomize the clock sequence bits |