Re: order by query wrong result - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: order by query wrong result
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17D9FF15@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to order by query wrong result  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
Responses Re: order by query wrong result  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
List pgsql-admin
Silvio Brandani wrote:
> we have a  query with wrong result  in order by :

Ordering depends on the collation, and that depends on the operating system.

What are the values of the parameters "lc_collate" and "server_encoding" of your database?
What is your operating system?
If the column you order by is defined with a nonstandard collation,
what is that collation?

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: order by query wrong result
Next
From: "ktm@rice.edu"
Date:
Subject: Re: order by query wrong result