Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group