Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
Description:Order by doesn't sort correctly.
It almost certainly is the correct sort order according to the locale
you're using. Use pg_controldata to check the database locale. You'll
probably want to re-initdb in C lo
Dear Tom,
Thank you for your explanation. It's very helpful, although I was
extremely surprised! I agree, it's not a postgresql bug.
Can I suggest it might be worth a mention on the "Order By" part of the
documentation.
i.e. this page:
http://www.postgresql.org/docs/7.3/static/sql-select.html#
Andreas Pflug <[EMAIL PROTECTED]> writes:
> I verified this, and it's not GB specific as one might suggest... Same
> with en_US, de_DE, fr_FR, af_ZA.
Yeah, most of the locales use dictionary ordering rules.
> Does this behaviour really make sense to anybody?
You'd have to argue about it with th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Feb 2004, Andreas Pflug wrote:
> I verified this, and it's not GB specific as one might suggest... Same
> with en_US, de_DE, fr_FR, af_ZA. Does this behaviour really make sense
> to anybody?
Ummm, same with tr_TR (for a long time)
Tom Lane wrote:
Richard Neill <[EMAIL PROTECTED]> writes:
This ordering is perverse!
No kidding.
No matter what the priority is of the
different characters, I cannot understand how the above can arise.
You are assuming that it's a byte-at-a-time process. It's not. I
believe the
Richard Neill <[EMAIL PROTECTED]> writes:
> This ordering is perverse!
No kidding.
> No matter what the priority is of the
> different characters, I cannot understand how the above can arise.
You are assuming that it's a byte-at-a-time process. It's not. I
believe the first pass considers onl
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> Description:Order by doesn't sort correctly.
It almost certainly is the correct sort order according to the locale
you're using. Use pg_controldata to check the database locale. You'll
probably want to re-initdb in C locale. Most non-
