-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
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.
Regards Gaetano Mendola.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAptPG7UpzwH2SGd4RAhGYAKDMCfPhsBCwGAIFFTH2YHD/fHK2VACfZeUU Y2nIWu56nvwhpZDTq1ARueo= =b84w -----END PGP SIGNATURE-----
emaildt_alpha.tgz
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings