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).
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? |