Re: Control PhoneNumber Via SQL

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com>
Cc: tango ward <tangoward15(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Control PhoneNumber Via SQL
Date: 2018-05-15 15:23:14
Message-ID: 20180515152314.ftp4h4efyjzvsdzg@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-May-15, John McKown wrote:
> I don't have any code for you, if that is what you are soliciting. I did
> find a couple of informative web sites which help explain how international
> phone numbers are formatted. These are known as E.164 numbers.

Michael Glaesemann wrote a e.164 datatype years ago, which I later
tweaked slightly: https://github.com/alvherre/e164

I don't know its status -- not sure if it even compiles. But it might
be a useful as a starting point.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rhys A.D. Stewart 2018-05-15 15:30:16 Combining \i and \copy in psql
Previous Message ChatPristi 2018-05-15 15:02:48 Out of memory error with PG10.3, 10.4 but not 9.3.19