Re: Looking for types: phone number, email addresses

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Looking for types: phone number, email addresses
Date: 2002-07-19 14:44:40
Message-ID: 20020719144440.GA24237@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 19, 2002 at 03:40:36PM +0100,
Oliver Elphick <olly(at)lfix(dot)co(dot)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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-07-19 14:51:46 Re: Looking for types: phone number, email addresses
Previous Message Jan Wieck 2002-07-19 14:41:28 Re: Linux max on shared buffers?