| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgman(at)candle(dot)pha(dot)pa(dot)us>, <mike(at)fuhr(dot)org>, <kg(at)kgb(dot)une(dot)edu(dot)au>, <grzm(at)myrealbox(dot)com>, <pgsql-hackers(at)postgreSQL(dot)org>, <mr-russ(at)pws(dot)com(dot)au>, <hb(at)x256(dot)com> |
| Subject: | Re: [BUGS] BUG #1993: Adding/subtracting negative |
| Date: | 2005-10-26 17:30:58 |
| Message-ID: | 435F77040200002500000273@gwmta.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I'm not seeing it. It seems to me that timestamps can be defined
WITH or WITHOUT time zone, and the semantics of calculating an
interval are fairly clear in either case. An interval doesn't seem
like it should have an associated time zone. Adding an interval
to a timestamp would use the time zone of the timestamp.
What am I missing?
-Kevin
>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> >>>
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> The standard seems rich enough in this area to
> address all of the concerns I've seen expressed on this thread.
> All the usual advantages for standards compliance accrue, as well.
Last I checked, the standard completely failed to deal with daylight
savings time changes, making it pretty useless as a guide to solving
the problems we want to deal with.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-26 17:32:06 | Re: IMMUTABLE bug ? |
| Previous Message | Alon Goldshuv | 2005-10-26 17:20:41 | Libpq optimization |