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