Re: email data type first release

...
>
> 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.

b(at)a(dot)domain(dot)com < a(at)b(dot)domain(dot)com
and
b(at)b(dot)a(dot)com < b(at)a(dot)b(dot)com

we get then the order:
a(at)a(dot)a(dot)com < a(at)b(dot)a(dot)com < a(at)a(dot)b(dot)com < a(at)b(dot)b(dot)com

rather than (in normal text-order):
a(at)a(dot)a(dot)com < a(at)a(dot)b(dot)com < a(at)b(dot)a(dot)com < a(at)a(dot)b(dot)com

Tommi