Re: US Telephone Number Type - Mailing list pgsql-general

From Vivek Khera
Subject Re: US Telephone Number Type
Date
Msg-id FD759281-D9EC-427C-AF6F-C62C72ACF95C@khera.org
Whole thread Raw
In response to US Telephone Number Type  ("Karen Hill" <karen_hill22@yahoo.com>)
Responses Re: US Telephone Number Type  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
On Jul 10, 2006, at 1:33 PM, Karen Hill wrote:

> Is the difficulty of creating a telephone type the reason it is not in
> postgresql already?
>
> Should the telephone type be able to do something such as:
>
> SELECT * from tableFOO where telephone.areacode = 555;
>
> Or would regex be better?

makes more sense to store them in a a canonical format and then find
things with pattern matches.



Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: US Telephone Number Type
Next
From: Jorge Godoy
Date:
Subject: Re: US Telephone Number Type