Re: order by query wrong result

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Silvio Brandani *EXTERN*" <silvio(dot)brandani(at)tech(dot)sdb(dot)it>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: order by query wrong result
Date: 2014-11-19 14:25:40
Message-ID: A737B7A37273E048B164557ADEF4A58B17D9FF15@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2014-11-19 14:27:00 Re: order by query wrong result
Previous Message Scott Ribe 2014-11-19 14:13:56 Re: order by query wrong result