hubert depesz lubaczewski 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 reas
On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote:
> "Alexander Loechel" writes:
> > After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the
> > to_timestamp methode produces different results.
>
> > in a CREAT View statement I have following methode call:
> > to_timestamp(dbtim
"Alexander Loechel" writes:
> After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the
> to_timestamp methode produces different results.
> in a CREAT View statement I have following methode call:
> to_timestamp(dbtimestamp, '/MM/DD HH24:MI:SS TZ') AS "timestamp"<<
> Where dbtimest
The following bug has been logged online:
Bug reference: 5714
Logged by: Alexander Loechel
Email address: alexander.loec...@unibw.de
PostgreSQL version: 8.4.5
Operating system: Ubuntu Server 10.04. LTS
Description:TZ pattern error on to_timestamp
Details:
After an u