Skip site navigation (1) Skip section navigation (2)

Re: BUG #5714: TZ pattern error on to_timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5714: TZ pattern error on to_timestamp
Date: 2010-10-17 15:28:51
Message-ID: 9820.1287329331@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote:
>> Testing shows that that example fails in every Postgres release back to
>> 7.1.  The spelling of the error message varies a bit, but they all agree
>> that a TZ format spec isn't supported.

> Any reason why Pg can't parse TZ?

Nobody's bothered to do the work ...

> perhaps it should be also listed in
> http://www.postgresql.org/docs/current/interactive/functions-formatting.html
> doc, that you can't use TZ (and some other patterns too)?

Nobody's bothered to do the work for that, either.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Jeff DavisDate: 2010-10-17 22:48:48
Subject: Re: Recovery bug
Previous:From: hubert depesz lubaczewskiDate: 2010-10-17 15:23:20
Subject: Re: BUG #5714: TZ pattern error on to_timestamp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group