... > > Another thing is that it might make more sense to sort email addresses by > domain first (case insensitively of course), then by left hand side (case > sensitively). Since the domain is really the "most significant bit". This > is also convenient for many systems like email since they perform better > when they can handle data in that order. > > Note that this would make the type sort differently from its text > representation. This shouldn't really be a problem but occasionally you see > poorly written queries that introduce extra type conversions that the user > doesn't expect. But then if it behaves just like the text datatype then > there wouldn't be much point in using it.
Sorting should then be done by top-level-domain first. Then 2nd, 3rd... and last by user. [EMAIL PROTECTED] < [EMAIL PROTECTED] and [EMAIL PROTECTED] < [EMAIL PROTECTED] we get then the order: [EMAIL PROTECTED] < [EMAIL PROTECTED] < [EMAIL PROTECTED] < [EMAIL PROTECTED] rather than (in normal text-order): [EMAIL PROTECTED] < [EMAIL PROTECTED] < [EMAIL PROTECTED] < [EMAIL PROTECTED] Tommi ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster