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 20020719144440.GA24237@nic.fr
Whole thread Raw
In response to Re: Looking for types: phone number, email addresses  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
On Fri, Jul 19, 2002 at 03:40:36PM +0100,
 Oliver Elphick <olly@lfix.co.uk> wrote
 a message of 23 lines which said:

> That would match "+0 ", which is probably not a valid number.

With integrity constraints, you have to know when you stop :-) Not
everything can be declared in SQL (I'm still searching for a way to
have a trigger fire at the end of a *transaction*, in order to check
cross-table integrity), so no check is perfect. I just wanted to catch
the majority of the mistakes that people can do when they type phone
numbers, not all of them.

Many thanks to all for the advices (and to Oliver for the Debian
package since this is the one I use).


pgsql-general by date:

Previous
From: Josh Jore
Date:
Subject: Re: Looking for types: phone number, email addresses
Next
From: grant
Date:
Subject: Re: Multi-Versions and Vacuum