From: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
---|---|
To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
Cc: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>, John Scalia <jayknowsunix(at)gmail(dot)com>, Silvio Brandani <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:39:23 |
Message-ID: | CAJghg4+r4WRsGM_K0G6swXaKCMdRMN-QXu7hsM6aHx0112q-5A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Nov 19, 2014 at 12:34 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:
> Yes, I know. On my first attempt I couldn't imagine any reasonable rule
> which would result in that order. But on a second try, I see one...
If you ignore dots, spaces, and dashs, you have that result. Looks like it
is what your collate is doing (and possible ignoring other characters).
Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2014-11-19 14:43:16 | Re: order by query wrong result |
Previous Message | Scott Ribe | 2014-11-19 14:34:09 | Re: order by query wrong result |