I need to sort the domains of email addresses from right to left, so that
all similar domains are grouped together. For instance, all .ca's will be
in the same batch.
I think I should be writing a trigger for this, using a secondary table
for the reverse domain name, then using a query like:
select email from table1, table2 where table1.oid=table2.id order by
table2.reverse_domain;
I'm not sure if keeping a secondary table is worthwhile, I will only be
executing this query about 50 times per day.
Let me know if there's a better way,
Marc Tardif