Re: Merging two columns into one

Thus spake Gary MacMinn
> I have two columns in a table (areacode and phone number) that I'd like to merge into one (phone number) containing
bothsets of info. Could anyone suggest a simple way of achieving this?
 

Oliver showed you how to merge these together with the SQL concatenate
operator but there is another possibility.  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.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.