Re: Combining data in different rows?

Bruno Wolff III wrote:
> On Tue, Jan 02, 2007 at 12:33:14 -0700,
>   Anthony Masinton <amasinton@gmail.com> 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"