| From: | "Cade Cairns" <cadec(at)otii(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3607: timestamp is behaving strangely |
| Date: | 2007-09-07 19:42:46 |
| Message-ID: | 200709071942.l87JgkQ9066062@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3607
Logged by: Cade Cairns
Email address: cadec(at)otii(dot)com
PostgreSQL version: 8.1.9
Operating system: Mac OS X 10.4.10
Description: timestamp is behaving strangely
Details:
test=> select '2007-05-11 09:33:01.167885'::timestamp without time zone,
('epoch'::timestamp without time zone + '1178875981.167885
seconds'::interval)::timestamp without time zone;
timestamp | timestamp
----------------------------+----------------------------
2007-05-11 09:33:01.167885 | 2007-05-11 09:33:01.167885
(1 row)
test=> select '2007-05-11 09:33:01.167885'::timestamp without time zone =
('epoch'::timestamp without time zone + '1178875981.167885
seconds'::interval)::timestamp without time zone;
?column?
----------
f
(1 row)
Why?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-07 20:04:17 | Re: BUG #3606: Query Plan Failure or Index Corruption? |
| Previous Message | David Tulloss | 2007-09-07 19:34:11 | BUG #3606: Query Plan Failure or Index Corruption? |