-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Bruno Wolff III wrote:
| On Sun, May 16, 2004 at 04:36:55 +0200, | Gaetano Mendola <[EMAIL PROTECTED]> 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-----
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
