From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Email data type |
Date: | 2004-05-17 15:01:36 |
Message-ID: | 40A8D3D0.7020103@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Bruno Wolff III wrote:
| On Sun, May 16, 2004 at 04:36:55 +0200,
| Gaetano Mendola <mendola(at)bigfoot(dot)com> wrote:
|
|>The type is indexable and provide also conversion methods:
|>
|>text <--> email
|>and the operator >>, is possible use it in select like:
|
|
| When you are converting between text and email data, what format are the
| text version of the address going to be? For example you might be using
| rfc2821 encoding, rfc2822 encoding or concatenating the local part,
| an @ sign and the domain name. Don't forget about domain literals.
Actually I use <local_part>@<domain_name>
Also the validator will validate emails in this form, if you are thinking to
validate emails as:
"Gaetano M. Public"(junior)<gmendola@(new account)bigfoot.com>
that are perfectly valid I think that it's a valid option to consider.
About the domain literals, I think to validate it in the near future,
rejecting private subnet according to this list:
10.0.0.0 - 10.255.255.255
172.16.0.0 - 172.31.255.255
192.168.0.0 - 192.168.255.255
169.254.0.0 -169.254.255.255
I think I have to discard also the addresses with last octet equal to 256.
Any comments ?
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAqNPP7UpzwH2SGd4RAgqxAJ9UCPOOTpPN6Tl9w1748inn7t4a/QCg7pl1
8O3lHDwEKsCuCOJYQAo0vHM=
=wFo+
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-05-17 15:11:42 | Re: email data type first release |
Previous Message | Jan Wieck | 2004-05-17 14:58:31 | Re: Multiple Xids in PGPROC? |