Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TbZ7H-0002nY-O4
	for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 15:55:03 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TbZ7F-0007GM-AH
	for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 15:55:02 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id qAMFt0PS027541;
	Thu, 22 Nov 2012 10:55:00 -0500 (EST)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Anibal David Acosta" <aa@devshock.com>
cc: pgsql-admin@postgresql.org
Subject: Re: timezone, how postgres deal with it?
In-reply-to: <004701cdc8c7$3a5cf4b0$af16de10$@devshock.com>
References: <004701cdc8c7$3a5cf4b0$af16de10$@devshock.com>
Comments: In-reply-to "Anibal David Acosta" <aa@devshock.com>
	message dated "Thu, 22 Nov 2012 12:36:42 -0300"
Date: Thu, 22 Nov 2012 10:55:00 -0500
Message-ID: <27540.1353599700@sss.pgh.pa.us>
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201211/118
X-Sequence-Number: 40363

"Anibal David Acosta" <aa@devshock.com> writes:
> This query returns false
> select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) =
> ('2012-11-20 18:00:00-03:00'::timestamp with time zone)
> But are exactly same time

No, they aren't.  You're apparently still confused about the sign of
timezone offsets.  The first one corresponds to 19:00 GMT, the second
to 21:00 GMT.

BTW, why are you posting the exact same question you posted two days
ago on another list?

			regards, tom lane