| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: timestamp with time zone a la sql99 |
| Date: | 2004-10-25 20:22:29 |
| Message-ID: | Pine.LNX.4.44.0410252221150.2015-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 25 Oct 2004, Josh Berkus wrote:
> > The standard restrict the hour field to the interval 0-23, so there can
> > never be any compare between for example '1 day 1 hour' and '25 hours'.
> > This means that one can not add two intervals together to get a bigger
> > one but that it would still work to do timestamp+interval+interval.
>
> Hour field of the timestamp, or hour field of interval? There a world of
> difference.
Hour field of an interval can be 0-23 according to the spec (doesn't say
that we need that restriction, but we do need to understand what the spec
say).
--
/Dennis Björklund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-10-25 20:32:37 | Re: timestamp with time zone a la sql99 |
| Previous Message | Josh Berkus | 2004-10-25 20:20:01 | Re: timestamp with time zone a la sql99 |