Re: Problem handling timezones

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Claudio Lapidus" <clapidus(at)ta(dot)telecom(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem handling timezones
Date: 2003-01-15 22:55:57
Message-ID: 1593.1042671357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Claudio Lapidus" <clapidus(at)ta(dot)telecom(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-16 00:32:17 Re: Problem handling timezones
Previous Message Tom Lane 2003-01-15 22:50:33 Re: CREATE TYPE example needed