Re: Timestamp with timezone question.

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