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: (view raw, whole thread or download thread mbox)
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?

Gary MacMinn


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-2017 The PostgreSQL Global Development Group