Re: merge result sets

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: simon <simon(dot)litwan(at)wyona(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: merge result sets
Date: 2006-06-21 10:34:58
Message-ID: 20060621103458.GC7859@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-06-21 11:13:23 Re: A slow query - Help please?
Previous Message simon 2006-06-21 10:23:44 Re: merge result sets