Received: from iolite.sge.net (iolite.sge.net [152.91.14.26]) by hub.org (8.10.1/8.10.1) with ESMTP id e5QNBU130547 for ; Mon, 26 Jun 2000 19:11:31 -0400 (EDT) Received: from cadmium.sge.net (cadmium.sge.net [152.91.9.5]) by iolite.sge.net (Postfix) with ESMTP id ABE05BD19 for ; Tue, 27 Jun 2000 09:11:27 +1000 (EST) Received: (from uucp@localhost) by cadmium.sge.net (8.9.3/8.9.3) id JAA29702 for ; Tue, 27 Jun 2000 09:11:26 +1000 (EST) Received: from nodnsquery(10.1.2.11) by cadmium.sge.net via smap (V5.0) id xma029297; Tue, 27 Jun 00 09:11:12 +1000 Received: from amber (ice-int2.sge.net [10.1.2.254]) by kryptonite.sge.net (8.9.3/8.9.3) with SMTP id JAA50215 for ; Tue, 27 Jun 2000 09:11:12 +1000 (EST) Message-Id: X-Mailer: Novell GroupWise 5.2 Date: Tue, 27 Jun 2000 09:09:42 +1000 From: "Gary MacMinn" To: pgsql-sql@postgresql.org Subject: Re: Merging two columns into one Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e5QNBW130549 X-Archive-Number: 200006/233 All, Many thanks for your thoughts on the merging of columns. The tr method would have killed all the delimiters as a few people noted. The || method in SQL was the winner, although the final table this has to be done to (4 million records) should kill the system for a while!!!!! Must make sure I've got enough disk space to do it all as well. Maybe doing it a section at a time would be in order. Thanks to all, Gary MacMinn