Re: Merging two columns into one

Christopher Sawtell wrote: >On Fri, 23 Jun 2000, Gary MacMinn wrote: >> Hi All, >>  >> I have two columns in a table
(areacodeand phone number) that I'd like to     > merge >into one (phone number) containing both sets of info. Could
anyonesuggest a >simple way of achieving this? > >export the data to a file using the copy command, >remove the
delimiterwith the unix command 'tr -d' >import the file, now minus the delimeter using the copy command.
 

Surely tr will remove ALL the delimiters, so this is not helpful
unless these columns are the only ones in the table.  You would
have to use awk or perl to process the exported file and delete
the correct delimiter.

For an SQL solution, how about:
 SELECT col1, col2,..., areacode || phone as phone, colx, coly,...    INTO new_table    FROM table;

Then you can drop the old table and recreate it with the correct
columns and import the data into it from new_table.  (You could
just rename new_table if it doesn't need to be created with
constraints.)

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Train up a child in the way he should go, and when he      is old, he will
notdepart from it."    Proverbs 22:6