Re: merge result sets - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: merge result sets
Date
Msg-id 20060621103458.GC7859@svana.org
Whole thread Raw
In response to Re: merge result sets  (simon <simon.litwan@wyona.com>)
Responses Re: merge result sets
List pgsql-general
On Wed, Jun 21, 2006 at 12:23:44PM +0200, simon wrote:
> or in other words, i just would like to know how to rewrite
>
> SET kategorie = array_to_string ((SELECT ARRAY (SELECT
> kategorie_bezeichnung
>
> so it works in psql7.3 as well.

The aggregate stuff should work. something like:

SET kategorie = (SELECT comma_aggregate(kategorie_bezeichnung) FROM ...)

should do the trick.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: simon
Date:
Subject: Re: merge result sets
Next
From: Alban Hertroys
Date:
Subject: Re: A slow query - Help please?