Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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
- References:
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Tom Lane
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Tom Lane
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Tom Lane
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Tom Lane
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- Prev by Date: Re: Strange interval arithmetic
- Next by Date: Re: [ADMIN] ERROR: could not read block
- Previous by thread: Re: Strange interval arithmetic
- Next by thread: Re: Strange interval arithmetic
- Indexes: