Received: from sivka.carrier.kiev.ua (root@sivka.carrier.kiev.ua [193.193.193.101]) by hub.org (8.10.1/8.11.0) with ESMTP id e9GM3VW41130 for ; Mon, 16 Oct 2000 18:03:33 -0400 (EDT) (envelope-from evpopkov@carrier.kiev.ua) Received: from planka.carrier.kiev.ua (root@users.lucky.net [193.193.193.106]) by sivka.carrier.kiev.ua (8/Kilkenny_is_better) with ESMTP id BBI46020 for ; Tue, 17 Oct 2000 01:03:27 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: from ed.ed (ln2-3.users.lucky.net [193.193.199.3]) by planka.carrier.kiev.ua (8) with ESMTP id BBI67102 for ; Tue, 17 Oct 2000 01:03:26 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: (from root@localhost) by ed.ed (8.8.7/8.8.5) id WAA05323 for pgsql-sql@postgresql.org; Mon, 16 Oct 2000 22:01:59 GMT From: KuroiNeko Date: Mon, 16 Oct 2000 22:01:59 +0000 To: pgsql-sql@postgresql.org Subject: Formatting US phone numbers, was Variable-length Types Message-ID: <39EB7AD7.nail41212I95Y@ed.ed> User-Agent: nail 9.14 2000-06-26 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/150 X-Sequence-Number: 1812 Josh and anyone interested, I've slightly changed the function. C source of a standalone program is available from http://www.primechoice.com/hum/uspn.c Comments welcome. Thx Ed PS Lemme know if you need a function, callable from PGSQL -- Well I tried to be meek And I have tried to be mild But I spat like a woman And I sulked like a child I have lived behind the walls That have made me alone Striven for peace Which I never have known Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)