Re: Best way to store/search phone numbers? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Best way to store/search phone numbers?
Date
Msg-id Pine.LNX.4.30.0111022111230.874-100000@peter.localdomain
Whole thread Raw
In response to Re: Best way to store/search phone numbers?  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
Andrew Gould writes:

> I'd use different fields (country code, area code,
> phone number, extension, etc.) and instruct the users
> not to use punctuation.

This will break down once someone from a different area/country tries to
enter his phone number.

You think it won't happen?  I have tried to do business with quite a few
places that didn't think my business would happen.  (I didn't actually end
up happening, too.)

OTOH, I once did work for an ISP that had a very specific interest in the
breakdown of phone numbers by area code, exchange, and such.  I used a
text field with a couple of functional indexes, and it worked well for us.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Sourceforge moving from PostgreSQL to Oracle
Next
From: Bruce Momjian
Date:
Subject: Re: Sourceforge moving from PostgreSQL to Oracle