| 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: | Whole Thread | Raw Message | 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 |