X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 810D18B9E74 for ; Tue, 22 Feb 2005 07:46:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50250-02 for ; Tue, 22 Feb 2005 07:46:05 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 4BA8A8B9E49 for ; Tue, 22 Feb 2005 07:46:05 +0000 (GMT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id j1M8OB1M009718; Tue, 22 Feb 2005 10:24:11 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id j1M8OBpF009714; Tue, 22 Feb 2005 10:24:11 +0200 Date: Tue, 22 Feb 2005 10:24:11 +0200 (EET) From: Achilleus Mantzios To: Bruno Wolff III Cc: pgsql-sql@postgresql.org Subject: Re: Timestamp with timezone question. In-Reply-To: <20050222065946.GA5861@wolff.to> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/233 X-Sequence-Number: 20344 O Bruno Wolff III έγραψε στις Feb 22, 2005 : > On Mon, Feb 21, 2005 at 16:16:04 +0200, > Achilleus Mantzios 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