Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY a string - Mailing list pgsql-general

From Tom Lane
Subject Re: ORDER BY a string
Date
Msg-id 21804.1194365919@sss.pgh.pa.us
Whole thread Raw
In response to ORDER BY a string  (phazon <phazon.ml@gmail.com>)
List pgsql-general
Tree view 
phazon <phazon.ml@gmail.com> writes:
> I've "**" before the name in order to display them at first, but the 2
> chars "**" are ignored in the order by.

What's your lc_collate setting?  In locales other than "C" this is not
at all unexpected.

            regards, tom lane

pgsql-general by date:

Previous
From: phazon
Date:
Subject: ORDER BY a string
Next
From: brian
Date:
Subject: Re: Selecting all but a few fields in a query