Comment on timezone and interval types - Mailing list pgsql-general

From Bruno Wolff III
Subject Comment on timezone and interval types
Date
Msg-id 20041023234915.GA12289@wolff.to
Whole thread Raw
Responses Re: Comment on timezone and interval types
Re: Comment on timezone and interval types
List pgsql-general
Recently there has been some discussion about attaching a timezone to
a timestamp and some other discussion about including a 'day' part
in the interval type. These two features impact each other, since
if you add a 'day' to a timestamp the result can depend on what timezone
the timestamp is supposed to be in. It probably makes more sense to use
a timezone associated with the timestamp than say the timezone GUC or the
fixed timezone UTC.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
Next
From: Tom Lane
Date:
Subject: Re: field incrementing in a PL/pgSQL trigger