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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
