Skip site navigation (1) Skip section navigation (2)

Re: Interval->day patch

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Glaesemann <grzm(at)myrealbox(dot)com>,pgsql-patches Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Interval->day patch
Date: 2005-07-20 17:34:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > We have this TODO item:
> >         o Allow TIMESTAMP WITH TIME ZONE to store the original timezone
> >           information, either zone name or offset from UTC [timezone]
> >           If the TIMESTAMP value is stored with a time zone name, interval
> >           computations should adjust based on the time zone rules.
> > It was originally added so we could distinguish 24 hours from 1 day.  Do
> > we still need this TODO?
> That's a completely separate TODO item.

OK.  Is it clear enough?

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Kris JurkaDate: 2005-07-20 17:50:06
Subject: Re: pgsql: Add 'day' field to INTERVAL so 1 day interval can be
Previous:From: Tom LaneDate: 2005-07-20 17:31:38
Subject: Re: Interval->day patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group