Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5121F930E1E for ; Fri, 3 Aug 2012 15:25:49 -0300 (ADT) Received: from fep19.mx.upcmail.net ([62.179.121.39]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SxMZI-0007IN-2s for pgsql-admin@postgresql.org; Fri, 03 Aug 2012 18:25:48 +0000 Received: from edge04.upcmail.net ([192.168.13.239]) by viefep19-int.chello.at (InterMail vM.8.01.05.05 201-2260-151-110-20120111) with ESMTP id <20120803182534.QWZY26940.viefep19-int.chello.at@edge04.upcmail.net>; Fri, 3 Aug 2012 20:25:34 +0200 Received: from [192.168.0.101] ([89.134.225.226]) by edge04.upcmail.net with edge id iJRZ1j0054tiMtV04JRZPu; Fri, 03 Aug 2012 20:25:34 +0200 X-SourceIP: 89.134.225.226 Message-ID: <501C179C.7020707@shopzeus.com> Date: Fri, 03 Aug 2012 20:25:32 +0200 From: Laszlo Nagy User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org, Tom Lane Subject: Re: Messed up time zones References: <501B8C6F.6040100@shopzeus.com> <501BAA84.9010306@shopzeus.com> <501BAE33.4090102@shopzeus.com> <16399.1344003584@sss.pgh.pa.us> <501BED07.5070603@shopzeus.com> <501BEF7C.1030403@dhs-club.com> <501BF70E.4090903@shopzeus.com> <19252.1344011891@sss.pgh.pa.us> In-Reply-To: <19252.1344011891@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/31 X-Sequence-Number: 39852 > [ shrug... ] If you really insist on re-inventing that wheel, go ahead, but it sounds to me like you'll just be introducing additional points of failure. regards, tom lane I just checked some programming languages (Python, C#), and the same problem exists there. All of them say that "when the time is ambiguous, then it is assumed to be in standard time". So the representation is ambiguous in various programming languages too. You are right - it would be reinventing the wheel. Although I don't like the fact that we are using an ambiguous system for measuring time, after all the problem was in my head. I'm sorry for being hardheaded.