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
