Re: PostgreSQL Top 10 Wishlist - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: PostgreSQL Top 10 Wishlist
Date
Msg-id 20060116214648.GK67693@pervasive.com
Whole thread Raw
In response to Re: PostgreSQL Top 10 Wishlist  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
On Mon, Jan 16, 2006 at 12:13:15PM -0500, Chris Browne wrote:
> What you seem to be after, here, would confine your telno formatting
> to telephone numbers for Canada and the United States, and would break
> any time people have a need to express telephone numbers outside those
> two countries.
>
> It would be quite interesting to add an EB164 type, as it could
> represent phone numbers considerably more compactly than is the case
> for plain strings.  The 20 digits permissible across 1. and 2. could
> be encoded in... 68 bits.

And it would be trivial to provide functions to map that into the
customary format for various countries. In fact, since there's 4 bits
left over, it might be possible to encode the formatting used for the
number in the storage itself.

BTW, you sure about 68 bits? That doesn't seem to allow for a full 20
digit number; or are there restrictions on the max value for one of the
fields?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Plans for 8.2?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Unable to connect to a dabase