create table t (name varchar);
insert into t values ('co.aaa');
insert into t values ('co.abb');
insert into t values ('co.cab');
insert into t values ('com');
insert into t values ('co.ment');
insert into t values ('com.enta');
select name from t order by replace(name, '.', '');
Jon
> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-
> owner@xxxxxxxxxxxxxx] On Behalf Of Pierre LEBRECH
> Sent: Tuesday, March 25, 2008 9:56 AM
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: How to sort strings containing a dot?
>
> 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
