From: Nick Fankhauser <nickf@ontko.com>
To: pgsql-sql@postgresql.org
Subject: interesting SQL puzzle - concatenating column with itself.
Date: Sun, 08 May 2005 13:55:56 -0500
Message-ID: <427E60BC.8060701@ontko.com> (raw)
Hi- I'm doing a conversion from an older database in which a memo field was handled by storing one line per record and then displaying the related records in order. I want to compress all of the lines into a single text field with one record per memo entry.
So for instance, the old database looks like this:
memo_id | sequence | memo_text
---------------------------------------
666 | 1 | The quick
666 | 2 | red fox
666 | 3 | jumped over
666 | 4 | the lazy brown dog
And my goal is to transform each group of lines into a single record that looks like this:
memo_id | memo_text
----------------------------------------------------------
666 | The quick red fox jumped over the lazy brown dog
Any thoughts on how to do this via sql? I could write a little program to do it, but it seems like there must be a pure-SQL solution that I'm not seeing.
Thanks
-Nick
--
------------------------------------------------------------------
Nick Fankhauser
nickf@ontko.com Phone 765.935.4283 Fax 765.962.9788
Ray Ontko & Co. - Software Consulting Services
http://www.ontko.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nickf@ontko.com
Subject: Re: interesting SQL puzzle - concatenating column with itself.
In-Reply-To: <427E60BC.8060701@ontko.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox