Re: [HACKERS] Copy from/to asymmetry

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Robinson <robinson(at)netrinsics(dot)com>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] Copy from/to asymmetry
Date: 2000-01-14 15:12:06
Message-ID: 387F3CC6.73F6BA7C@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> The GMT+8 format is part of the POSIX standard (at least according to
> the zoneinfo source file). In the meantime, I've created a new zoneinfo
> file with ISO "+0800" format, as a workaround. (To make matters worse, I
> discovered that POSIX GMT+8 == ISO -0800 ; in other words, the semantics of
> the sign character are reversed in the two standards.)

Yuck.

> Perhaps, if the system supports strptime(), this function could be used as
> a last-ditch effort by ParseDateTime before returning an error. That would
> solve all cases where the datetime_in timezone equals the system timezone
> setting.

How? strptime() needs a formatting string, so you would somehow need
to set it beforehand to *exactly* the correct value. And...

> Or, maybe just use strptime() outright. I don't know, it's just a suggestion.

The other problem with using system-supplied routines for this is that
they invariably fail for years outside the Unix system time range. So
we need to do enough parsing to figure out what the year might be, and
by that time we may as well finish it ourselves...

Anyway, I'll be looking at it sometime soon.

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-14 15:14:22 Re: [HACKERS] Re: Informix and OUTER join syntax
Previous Message Tom Lane 2000-01-14 15:11:26 Re: [HACKERS] [hackers]development suggestion needed