Postgres Pro
Downloads
Home   >   mailing lists

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

From Silvio Brandani
Subject Re: order by query wrong result
Date
Msg-id 546CBDF1.2030007@tech.sdb.it
Whole thread Raw
In response to Re: order by query wrong result  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: order by query wrong result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hi,

  lc_collate
-------------
  en_US.UTF-8

  server_encoding
-----------------
  UTF8

we are on postgres 9.3.5 on Centos  6.5

Thanks

Silvio Brandani

Il 19/11/2014 15:25, Albe Laurenz ha scritto:
> 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


--------------------------------------------------------------------------------



This message is for the recipients only. If you receive it in error, please notify the sender and delete it together
withany attachments. For any further information, including our privacy policy please refer to
http://www.savinodelbene.com/privacy/



--------------------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: order by query wrong result
Next
From: Tom Lane
Date:
Subject: Re: order by query wrong result