Bruno Wolff III wrote:
On Tue, Jan 02, 2007 at 12:33:14 -0700,
Anthony Masinton <amasinton@xxxxxxxxx> wrote:
I would like to combine data from different rows in one column into
one row.
...
Is this possible and if so, how?
Collapsing rows is done with aggregate functions. You can write a custom
aggregate that collapses the wills for a particular city. How you do this
depends on how you want to store the combined wills (e.g. array, text string).
Check out the User Comments section at
"http://www.postgresql.org/docs/8.0/interactive/sql-createaggregate.html";
