Received: from propertykey.com (IDENT:root@propertykey.com [206.196.37.193]) by hub.org (8.10.1/8.10.1) with ESMTP id e5NFhe100498 for ; Fri, 23 Jun 2000 11:43:41 -0400 (EDT) Received: from propertykey.com (gotojail.propertykey.com [206.196.37.197]) by propertykey.com (8.9.3/8.9.3) with ESMTP id KAA04069; Fri, 23 Jun 2000 10:43:08 -0500 Message-ID: <39538562.1A0BB4BC@propertykey.com> Date: Fri, 23 Jun 2000 10:42:26 -0500 From: Jeff Hoffmann Organization: PropertyKey.com X-Mailer: Mozilla 4.72 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "D'Arcy J.M. Cain" CC: Gary MacMinn , pgsql-sql@postgresql.org Subject: Re: Merging two columns into one References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/209 "D'Arcy J.M. Cain" wrote: > > PostgreSQL could use a > phone number type. I have been meaning to write a user defined type > for some time but never seem to get around to it. Maybe you could > give this a shot. The examples in contrib should get you started. > Once finished you can make the phone # one column and split out parts > with various functions. Don't forget to have a place for country code > and extension. i messed around with one a while back, but i dropped it before i finished it. if i recall correctly, it was mostly working, but i don't know if i broke it again after that or not. i'll put a copy of it on my web site -- you can download it, clean it up and put it in contrib if you want. i just tarred up the files, there's no documentation for it & barely any copyright info in it. put whatever license you want on it if you want to reuse it. the files located at: http://www.potlatch.org/source/phone.tar.gz -- Jeff Hoffmann PropertyKey.com