Re: Email data type

Gaetano Mendola wrote:

> Hi all, this is the alpha version for the new email data type,
> is not written as built in type but as plug in, Tome Lane and others
> drove me in this direction.
> 
> The type is indexable and provide also conversion methods:
> 
> text <--> email
> and the operator >>, is possible use it in select like:
> 
> select * from my_user where email >> 'hotmail.com';
> 
> this select will extract all records with an email inside
> the domain 'hotmail.com'.
> 
> The validation routine is very simple, right now test only
> the presence of character '@' (it's an alpha version), I'd like
> to put it on pgfoundry but apparently my DNS are unable to resolve
> www.pgfoundry.org. I'll put this version as soon the address become
> available.
> 
> This is the first time that I wrote code for postgresql so please, if
> you can, do a sort of code revision on it.
> 
> Comments are welcomed.

Forget the version attached and use the version on pgfoundry.


Regards
Gaetano Mendola