Greg Stark wrote:
> Gaetano Mendola <mendola@bigfoot.com> writes:
>
>
>>Comments are welcomed.
>
>
> Well as long as you're asking...
>
> Email domains are case insensitive, but the left hand side is case sensitive.
> That's the only part that's hard to handle using a text data type, it would be
> kind of neat if the email operators got it right.
>
> 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.
That's true, I will order as Tommi Maekitalo suggest.
Regards
Gaetano Mendola
