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.