Re: email data type first release

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