Re: Day of week question

From: Randolf Richardson <rr(at)8x(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Day of week question
Date: 2003-11-29 05:54:56
Message-ID: Xns9441DCE3E113Err8xca@200.46.204.72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

[sNip]
> Why shall 1752 be the default date? The original introduction of
> gregorian dates after all was in 1582. And some parts of the earth
> didn't switch before the 20th century. So, as pointed out, we'd need a
> locale dependant default.

Since a database can be serving someone in a different locale from the
local one, this should be configurable at the SQL statement level.

It would probably also be good to have a system-wide configurable
default in one of the configuration files to satisfy the needs of those who
only need to use one system and wish to avoid the overhead of using non-
standard SQL statements.

--
Randolf Richardson - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Randolf Richardson 2003-11-29 06:15:51 Re: *sigh*
Previous Message Neil Conway 2003-11-29 05:21:34 Re: gettimeofday() goes backwards on FreeBSD 4.9