Tom Lane wrote:
But in any case, I've committed code that implements Oliver's idea. Could folks take another swipe at it and see if it works well in their local zones? Also, it'd still be interesting to see if we could #ifdef out the matching on zone names for Windows and still get reasonable results.
Sadly, it now thinks I live a bit further south than I actually do :)
template1=# show timezone; TimeZone -------------------- Antarctica/McMurdo (1 row)
The only timezones that get positive scores during startup are:
DEBUG: TZ "Antarctica/McMurdo" gets max score 2080 DEBUG: TZ "Antarctica/South_Pole" gets max score 2080 DEBUG: TZ "Pacific/Auckland" gets max score 2080 DEBUG: TZ "NZ" gets max score 2080
Either of "NZ" or "Pacific/Auckland" would be correct.
From memory it picked Pacific/Auckland with the slightly older code.
-O
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]