| From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg SQL question |
| Date: | 2005-01-22 21:03:58 |
| Message-ID: | 200501221403.58518.pgsql@bluepolka.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
There's probably an obvious answer for this, but I couldn't see it in the
docs. What's the simplest way to concatenate multiple same-column values
in SQL?
For example, suppose I have table foo (key integer, id integer, entry
varchar) with data
key id entry
1 1 "Four score and seven years ago our fathers "
1 2 "brought forth on this continent, a new nation, "
1 3 "conceived in Liberty, and dedicated to the "
1 4 "proposition that all men are created equal."
and I want to produce the following result:
"Four score and seven years ago our fathers brought forth on this continent,
a new nation, conceived in Liberty, and dedicated to the proposition that
all men are created equal."
I know this could be done writing a plpgsql function, but it seems so basic,
I thought there might be something I'm overlooking.
TIA.
Ed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-22 21:05:33 | Re: SSL |
| Previous Message | Tom Lane | 2005-01-22 19:58:12 | Re: Data format and display |