Re: Looking for types: phone number, email addresses

Поиск
Список
Период
Сортировка
От Stephane Bortzmeyer
Тема Re: Looking for types: phone number, email addresses
Дата
Msg-id 20020719140724.GA23564@nic.fr
обсуждение исходный текст
Ответ на Re: Looking for types: phone number, email addresses  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: Looking for types: phone number, email addresses  (Lee Kindness <lkindness@csl.co.uk>)
Re: Looking for types: phone number, email addresses  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-general
On Fri, Jul 19, 2002 at 02:47:43PM +0100,
 Oliver Elphick <olly@lfix.co.uk> wrote
 a message of 25 lines which said:

> CHECK (phone ~ '^\\+33 [0-9]( [0-9]{2}){4}$')
>
> That's only good for French numbers, since only France uses that
> grouping of digits for phone numbers.

OK, let's check:

CHECK (phone ~ '^\\+[0-9]+[ 0-9]+$')

which is, I believe, international (although the above regexp does not
prevent strange things like two consecutive spaces).

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

Предыдущее
От: "Gregory Wood"
Дата:
Сообщение: Re: 7.3 support for IN
Следующее
От: Lee Kindness
Дата:
Сообщение: Re: Looking for types: phone number, email addresses