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
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,
pgsql-general by date
|Next:||From: Bruce Bantos||Date: 2000-01-26 19:29:57|
|Subject: Backup, Vacuume scheduling tips?|
|Previous:||From: Peter Eisentraut||Date: 2000-01-26 18:34:06|
|Subject: Re: [GENERAL] what is "view?"|