| 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: | 2005-11-30 23:45:09 |
| Message-ID: | 20051130234509.GA28551@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-12-01 01:21:46 | Re: Upcoming PG re-releases |
| Previous Message | Michael Fuhr | 2005-11-30 23:15:33 | Re: Strange interval arithmetic |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-12-01 02:36:20 | Check for integer overflow in datetime functions |
| Previous Message | Michael Fuhr | 2005-11-30 23:15:33 | Re: Strange interval arithmetic |