| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | Magnus Hagander <mha(at)sollentuna(dot)net>, Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Weird new time zone |
| Date: | 2004-07-16 04:13:09 |
| Message-ID: | 15586.1089951189@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-hackers-win32 |
Oliver Jowett <oliver(at)opencloud(dot)com> writes:
> How about scanning backwards until you have <= 1 choice or decide to
> give up?
Hmm ... that really seems like not a bad idea. Scan all the available
timezones, score each on how far back it goes before a mismatch, take
the one that goes furthest back. I'm not sure what to do about ties,
nor what the minimum "passing score" ought to be, but seems like the
germ of an answer. Comments anyone?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2004-07-16 04:23:13 | Re: [HACKERS] Weird new time zone |
| Previous Message | Michael Glaesemann | 2004-07-16 03:58:52 | Converting epoch to timestamp |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2004-07-16 04:23:13 | Re: [HACKERS] Weird new time zone |
| Previous Message | Oliver Jowett | 2004-07-16 03:35:13 | Re: [HACKERS] Weird new time zone |