Re: Looking for types: phone number, email addresses - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Looking for types: phone number, email addresses
Date
Msg-id 20020719140724.GA23564@nic.fr
Whole thread Raw
In response to Re: Looking for types: phone number, email addresses  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Looking for types: phone number, email addresses
Re: Looking for types: phone number, email addresses
List 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 by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: 7.3 support for IN
Next
From: Lee Kindness
Date:
Subject: Re: Looking for types: phone number, email addresses