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 for
  Advanced Search

Re: Strange interval arithmetic


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