From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Subject: Re: Timestamp with timezone question.
Date: Tue, 22 Feb 2005 10:24:11 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0502221022290.7436-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <20050222065946.GA5861@wolff.to>
O Bruno Wolff III Ýãñáøå óôéò Feb 22, 2005 :
> On Mon, Feb 21, 2005 at 16:16:04 +0200,
> Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:
> >
> > Since pgsql always converts a timestamptz to UTC, we have lost
> > the information of the Sender's local timezone.
> >
> > Should i go with a separete date and timetz ?
>
> Someone else gave you a recommended solution.
>
> However there was a discussion on the order of 6 months ago about changing
> the timestamptz type to keep this information. Nothing will be changing
> in the near future, but you may (or may not) find the discussion useful.
Thanx,
i'll check it out sometime.
Apart from that, having a new (version of a) type (timestamptz)
just to provide a convinience function isnt too useful.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, bruno@wolff.to
Subject: Re: Timestamp with timezone question.
In-Reply-To: <Pine.LNX.4.44.0502221022290.7436-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox