| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Josh Jore <josh(at)greentechnologist(dot)org> |
| Cc: | Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>, Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Looking for types: phone number, email addresses |
| Date: | 2002-07-19 16:45:18 |
| Message-ID: | 20020719164518.GA13657@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 19, 2002 at 10:11:43 -0500,
Josh Jore <josh(at)greentechnologist(dot)org> wrote:
> Remember to allow quotes and spaces as well. This is a valid address (no,
> not that I actually defined it as an alias):
>
> "Josh Jore"@greentechnologist.org
You may not want to store rfc 821 encodings of addresses.
Josh Jore(at)greentechnologist(dot)org
is a valid email address. It just needs to be encoded when used in an
smtp transaction. Some MUAs don't have a way to inject messages with
unencoded email addresses. Others (such as qmail) do. Constraints on
unencoded addresses are going to be a lot simpler than those on rfc 821
encoded addresses.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2002-07-19 16:53:50 | Re: [SQL] id and ID in CREATE TABLE |
| Previous Message | Tom Lane | 2002-07-19 16:35:23 | Re: Multi-Versions and Vacuum |