Re: Interval->day patch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(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:31:38
Message-ID: 23931.1121880698@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-07-20 17:34:15 Re: Interval->day patch
Previous Message Bruce Momjian 2005-07-20 17:24:54 Re: pgsql: Add 'day' field to INTERVAL so 1 day interval