Postgres Pro
Downloads
Home   >   mailing lists

Re: How to sort strings containing a dot? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to sort strings containing a dot?
Date
Msg-id 22115.1206460727@sss.pgh.pa.us
Whole thread Raw
In response to How to sort strings containing a dot?  (Pierre LEBRECH <pierre.lebrech@laposte.net>)
List pgsql-general
Tree view 
Pierre LEBRECH <pierre.lebrech@laposte.net> writes:
> I want to sort strings containing a dot but by taking care of this dot
> like any other character.

I suspect what you really want is C locale, and what you've got is
some other locale that uses "dictionary" sort rules.  Try "show lc_collate".

            regards, tom lane

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: return value from SQL statement
Next
From: Pierre LEBRECH
Date:
Subject: Re: How to sort strings containing a dot?