Horton
Menu

Re: Tightening binary receive functions

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, James Pye <lists@jwp.name>, pgsql-hackers@postgresql.org
Date: 2009-11-10T16:54:44Z
Lists: pgsql-hackers 
FYI, Heikki has fixed this bug and the fix will appear in Postgres 8.5.

---------------------------------------------------------------------------

Andrew Gierth wrote:
> >>>>> "Heikki" == Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 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 (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +