Hello,
I was recently surprised to find that EXTRACT's day of the week
numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday
while TO_CHAR starts at 1==Sunday.
A suggestion for two documentation notes is attached as a patch to
current CVS HEAD.
--
Greetings from Troels Arvin,
Peter,
> > I think this means that in the basic install-from-source
> > instructions, we need to warn people to compile with --locale='C'.
>
> I think not.
Care to explain that? Why shouldn't we warn people?
Otherwise we're set for 12,000 e-mails to the SQL list on "why doesn't this
quer
Josh Berkus wrote:
> Otherwise we're set for 12,000 e-mails to the SQL list on "why
> doesn't this query use and index, it did on my old machine".
Linux distributions have been shipping with non-C locale settings for a
long, long time, so that complaint would be invalid. And even back
then we f
Peter,
> Linux distributions have been shipping with non-C locale settings for a
> long, long time, so that complaint would be invalid.
In US distributions it's a recent thing. The switch to non-C locales is a
recent thing; RH Enterprise 3.0, and SuSE 9.0. But I expect in Europe you've
been
On Monday 06 December 2004 13:39, Josh Berkus wrote:
> I'd like to have an explanation of this somewhere else newbies are liable
> to read it, *before* their first production "LIKE" query doesn't use an
> index. Where would be appropriate?
>
It's buried in the faq -> http://www.postgresql.org/docs
Josh Berkus wrote:
> In US distributions it's a recent thing. The switch to non-C
> locales is a recent thing; RH Enterprise 3.0, and SuSE 9.0.
I have it on record that Red Hat has set a non-C locale by default at
least since Red Hat 6.1 as distributed in North America (aren't they
the same an
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Josh Berkus wrote:
>> I'd like to have an explanation of this somewhere else newbies are
>> liable to read it, *before* their first production "LIKE" query
>> doesn't use an index. Where would be appropriate?
> Near the documentation of "LIKE".
I thi
