From: Silvio Brandani <silvio.brandani@tech.sdb.it>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: order by query wrong result
Date: Wed, 19 Nov 2014 16:57:37 +0100
Message-ID: <546CBDF1.2030007@tech.sdb.it> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B17D9FF15@ntex2010a.host.magwien.gv.at>
References: <546CA188.705@tech.sdb.it>
<A737B7A37273E048B164557ADEF4A58B17D9FF15@ntex2010a.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 with any attachments. For any further information, including our privacy policy please refer to http://www.savinodelbene.com/privacy/
--------------------------------------------------------------------------------
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: silvio.brandani@tech.sdb.it, laurenz.albe@wien.gv.at
Subject: Re: order by query wrong result
In-Reply-To: <546CBDF1.2030007@tech.sdb.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox