Re: Problem handling timezones - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem handling timezones
Date
Msg-id 1593.1042671357@sss.pgh.pa.us
Whole thread Raw
In response to Problem handling timezones  ("Claudio Lapidus" <clapidus@ta.telecom.com.ar>)
Responses Re: Problem handling timezones  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
"Claudio Lapidus" <clapidus@ta.telecom.com.ar> writes:
> FWIW, I browsed the source tree and found that "art" is already defined in
> datetime.c and appears to be included:

> $ grep -in '"ART"' /opt/pgsql/src/postgresql-7.3/src/backend/utils/adt/datetime.c
> 119:    {"art", TZ, NEG(12)},           /* Argentina Time */

> But it doesn't work, as shown above. Any hints?

Good catch.  I think the problem is that ART is out of order in the table,
so it's not being found by the binary-search algorithm.  Put it in
correct alphabetical order relative to the other entries, and I bet it
will work.

            regards, tom lane

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: last word in text
Next
From: Vivek Khera
Date:
Subject: Re: postgres on a PDA