Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Strange interval arithmetic


  • From: Michael Fuhr <mike@fuhr.org>
  • To: Tom Lane <tgl@sss.pgh.pa.us>
  • Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>, PostgreSQL-development <pgsql-hackers@postgresql.org>
  • Subject: Re: Strange interval arithmetic
  • Date: Wed, 30 Nov 2005 16:45:09 -0700
  • Message-id: <20051130234509.GA28551@winnie.fuhr.org>

Hmmm...is this something else that needs fixing?  The doc says dates
range from 4713 BC to 32767 AD.

test=> select '11754179-08-04'::date;
      date      
----------------
 11754179-08-04
(1 row)

test=> select '11754179-08-05'::date;
     date      
---------------
 4801-01-01 BC
(1 row)

-- 
Michael Fuhr



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group