From: Silvio Brandani <silvio.brandani@tech.sdb.it>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: order by query wrong result
Date: Wed, 19 Nov 2014 17:36:53 +0100
Message-ID: <546CC725.7000805@tech.sdb.it> (raw)
In-Reply-To: <27275.1416413426@sss.pgh.pa.us>
References: <546CA188.705@tech.sdb.it>
<A737B7A37273E048B164557ADEF4A58B17D9FF15@ntex2010a.host.magwien.gv.at>
<546CBDF1.2030007@tech.sdb.it>
<27275.1416413426@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I find this workaround:
CREATE OR REPLACE FUNCTION cleanup(text)
RETURNS text AS $$
SELECT replace(replace(replace($1, ' ','x'),'-','x'),'.','x')
$$ LANGUAGE sql;
and I get correct result :
select name
from prva
where name ilike 'savino del bene s%'
order by upper(cleanup(name));
Silvio Brandani
--
Il 19/11/2014 17:10, Tom Lane ha scritto:
> Silvio Brandani <silvio.brandani@tech.sdb.it> writes:
>> Hi,
>> lc_collate
>> -------------
>> en_US.UTF-8
> en_US (and, in fact, most Linux locales other than C) uses "dictionary
> order", which ignores pretty much everything except letters in its
> first-pass comparison.
>
> You can check that it's not just Postgres being weird by feeding the
> same data through sort(1) after setting LC_COLLATE this way in its
> environment. You'll get the same results.
>
> regards, tom lane
>
--------------------------------------------------------------------------------
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, tgl@sss.pgh.pa.us, laurenz.albe@wien.gv.at
Subject: Re: order by query wrong result
In-Reply-To: <546CC725.7000805@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