Re: Looking for types: phone number, email addresses

Поиск
Список
Период
Сортировка
От Josh Jore
Тема Re: Looking for types: phone number, email addresses
Дата
Msg-id Pine.BSO.4.44.0207191009130.2596-100000@kitten.greentechnologist.org
обсуждение исходный текст
Ответ на Re: Looking for types: phone number, email addresses  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
Ответы Re: Looking for types: phone number, email addresses
Re: Looking for types: phone number, email addresses
Список pgsql-general
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


Joshua b. Jore ; http://www.greentechnologist.org

On Fri, 19 Jul 2002, Stephane Bortzmeyer wrote:

> On Fri, Jul 19, 2002 at 03:27:19PM +0100,
>  Lee Kindness <lkindness@csl.co.uk> wrote
>  a message of 20 lines which said:
>
> Email addresses, on the other hand, *will* be used automatically
> (opt-in only, do not worry).
>
> At the present time, I use:
>
>  -- Not perfectly RFC 2822-compliant :-(
>  email TEXT NOT NULL CHECK (email ~ '^[a-zA-Z0-9\+\.\_\-]+@[a-zA-Z0-9\.\-]+$'),
>  phone TEXT CHECK (phone ~ '^\\+[0-9]+[ 0-9]+$'),
>  fax TEXT CHECK (fax ~ '^\\+[0-9]+[ 0-9]+$'),
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Linux max on shared buffers?
Следующее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: Looking for types: phone number, email addresses