RE: Order by email address by domain ? - Mailing list pgsql-sql

From Maxim Maletsky
Subject RE: Order by email address by domain ?
Date
Msg-id DC017B079D81D411998C009027B7112A015ED1A8@EXC-TYO-01
Whole thread Raw
In response to Order by email address by domain ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-sql
here's an idea:

if you would have all emails stored in the reverse order:
moc.niamod@resu

then all you would need is simple 'ORDER BY email'.

Also, in this way, emails like user@subdomain.domain.com would be perfectly
ordered.

Is that a crazy thought?

If not yet then: why not to add an additional field to the table with the
reverse domain only? (after an @) ordering by it. INDEX would also be
simple.

now is crazy? Then, is there any such function in PostgreSQL? With C it
would be so easy and fast.

Cheers!
Maxim Maletsky



-----Original Message-----
From: Hervé Piedvache [mailto:herve@elma.fr]
Sent: Friday, May 11, 2001 3:38 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Order by email address by domain ?


Hi,

I just want to order by a listing of email address by domain like :

toto@aol.com
tutu@aol.com
toto@be.com
tutu@be.com
toto@yahoo.com

Is it possible and how ?

Thanks !
-- 
Hervé Piedvache

Elma Ingenierie Informatique
6, rue du Faubourg Saint-Honoré
F-75008 - Paris - France 
http://www.elma.fr
Tel: +33-1-44949901
Fax: +33-1-44949902 
Email: herve@elma.fr

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl


pgsql-sql by date:

Previous
From: "datactrl"
Date:
Subject: Client Applications come with PostGreSQL V7.1
Next
From: "Jack"
Date:
Subject: Client Applications come with PostGreSQL V7.1