FYI, Heikki has fixed this bug and the fix will appear in Postgres 8.5. ---------------------------------------------------------------------------
Andrew Gierth wrote: > >>>>> "Heikki" == Heikki Linnakangas <[email protected]> > >>>>> writes: > > Heikki> Oops, you're right. The check is indeed confusing julian day > Heikki> numbers, with epoch at 23th of Nov 4714 BC, with > Heikki> postgres-reckoning day numbers, with epoch at 1th of Jan > Heikki> 2000. Thanks, will fix. > > Which reminds me: why isn't there an extract(jday from ...) function > or similar? > > -- > Andrew. > > -- > Sent via pgsql-hackers mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
