Postgres Pro
Downloads
Home   >   mailing lists

Re: order by query wrong result - Mailing list pgsql-admin

From Matheus de Oliveira
Subject Re: order by query wrong result
Date
Msg-id CAJghg4+r4WRsGM_K0G6swXaKCMdRMN-QXu7hsM6aHx0112q-5A@mail.gmail.com
Whole thread Raw
In response to Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view

On Wed, Nov 19, 2014 at 12:34 PM, Scott Ribe <scott_ribe@elevated-dev.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

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: order by query wrong result
Next
From: Scott Ribe
Date:
Subject: Re: order by query wrong result