Re: Is there a better way to do this?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Wei Weng <wweng(at)kencast(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a better way to do this?
Date: 2007-08-29 00:42:50
Message-ID: 73C57E0A-C87A-4B86-AE77-A2CE45B8B87C@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 28, 2007, at 19:30 , Tom Lane wrote:

> Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
>> Note that interval '1 day' is not equal to interval '24 hours'. '1
>> day' can be 23 or 25 hours across daylight saving time boundaries.
>
> When you are adding to timestamp without time zone, they *are*
> interchangeable, since no daylight-savings arithmetic is involved.
> Michael's right for the case of adding to timestamp with time zone,
> though.

Ah, right. Thanks for pointing that out.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-29 00:43:32 Re: Question regarding autovacuum
Previous Message Tom Lane 2007-08-29 00:37:12 Re: autovacuum not running