Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C65099FB4D7 for ; Sat, 14 Oct 2006 20:26:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55408-07 for ; Sat, 14 Oct 2006 20:26:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F292B9FB20D for ; Sat, 14 Oct 2006 20:26:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9ENQWkx013339; Sat, 14 Oct 2006 19:26:32 -0400 (EDT) To: chrisj cc: pgsql-sql@postgresql.org Subject: Re: Assigning a timestamp without timezone to a timestamp In-reply-to: <6815181.post@talk.nabble.com> References: <6613652.post@talk.nabble.com> <20061003135623.GB3191@phlogiston.dyndns.org> <6621346.post@talk.nabble.com> <20061003145134.GA3399@phlogiston.dyndns.org> <8C5B026B51B6854CBE88121DBF097A864DE848@ehost010-33.exch010.intermedia.net> <20061005183128.GD8826@phlogiston.dyndns.org> <6667446.post@talk.nabble.com> <20061005203121.GI8826@phlogiston.dyndns.org> <6815181.post@talk.nabble.com> Comments: In-reply-to chrisj message dated "Sat, 14 Oct 2006 14:42:39 -0700" Date: Sat, 14 Oct 2006 19:26:32 -0400 Message-ID: <13338.1160868392@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.089 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/133 X-Sequence-Number: 26522 chrisj writes: > It works fine with fixed offset timezones, but when I try it with EST5EDT > I get the following: > ERROR: invalid input syntax for type timestamp with time zone: "2006-07-13 > 09:20:00 EST5EDT" Try it with "America/New_York". The datetime parser seems to think that a timezone name shouldn't contain digits ... which is bogus, but we'll have to think carefully about how to improve it ... regards, tom lane