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