Merging two columns into one

From: "Gary MacMinn" <G(dot)MacMinn(at)nca(dot)gov(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Merging two columns into one
Date: 2000-06-23 03:04:59
Message-ID: s9536097.001@syd_aux.nca.gov.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

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

Thanks,
Gary MacMinn

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2000-06-23 05:10:38 Re: Merging two columns into one
Previous Message D'Arcy J.M. Cain 2000-06-23 02:43:38 Re: Using substr with user defined types