Matthias Apitz writes:
> Said that, does the SORT done by the server depends on the environment
> (LANG, LC_*) in which the PostgreSQL server is started or only of the
> sp_catalog information of the database in question?
We set LC_COLLATE and LC_CTYPE from the database's relevant
pg_database fie
El día Donnerstag, Februar 03, 2022 a las 10:00:37 -0500, Tom Lane escribió:
> Matthias Apitz writes:
> > El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz
> > escribió:
> >> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query:
> >> select katkey,normform fr
On Fri, Feb 4, 2022 at 8:11 AM Matthias Apitz wrote:
> On my FreeBSD laptop the same file sorts as
>
> guru@c720-r368166:~ $ LANG=de_DE.UTF-8 sort swd
> A
> ゲアハルト・A・リッター
> ゲルハルト・A・リッター
> チャールズ・A・ビアード
> A010STRUKTUR
> A010STRUKTUR
> A010STRUKTUR
> A0150SUPRALEITER
Wow, so it's one thing to have a
El día jueves, febrero 03, 2022 a las 10:00:37 -0500, Tom Lane escribió:
> Matthias Apitz writes:
> > El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz
> > escribió:
> >> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query:
> >> select katkey,normform from s
Matthias Apitz writes:
> El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz escribió:
>> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query:
>> select katkey,normform from swd_anzeige where normform >= 'A' ORDER BY ASC;
>> coming out in this order:
>> ...
>> I
El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz escribió:
>
> Hello,
>
> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query:
>
> select katkey,normform from swd_anzeige where normform >= 'A' ORDER BY ASC;
>
> coming out in this order:
>
> query: fetch
On 27.07.21 19:07, Marc Millas wrote:
so, obviously, both lc_collate knows about the é
but obviously, too, they do behave differently on the impact of the
beginning white space.
I didn't see anything about this behaviour on the doc, unless the
reference at the libc should be understood as ple
Marc Millas writes:
> Re-reading my post, I see that even the élise is not sorted correctly on
> w10...
Sort orders aren't even particularly guaranteed on different releases
of the same platform, let alone totally different platforms. glibc
made major changes to their collation rules not long ag
Re-reading my post, I see that even the élise is not sorted correctly on
w10...
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Tue, Jul 27, 2021 at 7:07 PM Marc Millas wrote:
> Hi,
>
> context:
> one postgres 12 on centos 7
> one postgres 12 on windows 10
> both on machines with
