Postgres Pro
Downloads
Home   >   mailing lists

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

From Pierre LEBRECH
Subject How to sort strings containing a dot?
Date
Msg-id 47E91272.9090001@laposte.net
Whole thread Raw
Responses Re: How to sort strings containing a dot?  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Re: How to sort strings containing a dot?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello,

I want to sort strings containing a dot but by taking care of this dot
like any other character.

example :

Currently, I get this after the sort :

co.aaa
co.abb
co.cab
com
co.ment
com.enta

But I would like to get this :

co.aaa
co.abb
co.cab
co.ment
com
com.enta

How I can do this?
Thank you

pgsql-general by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: select any table
Next
From: "Roberts, Jon"
Date:
Subject: Re: How to sort strings containing a dot?