Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Aug 2007 19:42:50 -0500
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
- References:
- Is there a better way to do this?
- From: Wei Weng
- Re: Is there a better way to do this?
- From: Michael Glaesemann
- Re: Is there a better way to do this?
- From: Tom Lane
- Is there a better way to do this?
- Prev by Date: Re: autovacuum not running
- Next by Date: Re: Question regarding autovacuum
- Previous by thread: Re: Is there a better way to do this?
- Next by thread: Re: Is there a better way to do this?
- Indexes: