DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=date:from:to:cc:subject:message-id:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=wXEA8hoRhdmNWCrkujWoHw+m9XjqdD9oN/OW9ld3RgHjGpxh/CsM2DE6Qh02l3GMxU
	bVbfJPoAsZilji8Yh0jtxodaqHq2W0akzFdOuPdcexvX2859DSFMvlfeqEYYN3EcCkJb
	2oIWMN1JEo08vPj5koyI8wrvbzE8t8mQUZYms=
Date: Fri, 31 Jul 2009 17:29:35 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Andreas <maps.on@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: How fetch multiple rows into one text-field?
Message-ID: <20090731232935.GZ4385@eddie>
References: <4A734F8A.906@gmx.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="B2XwZuBUJ8PPSpsy"
Content-Disposition: inline
In-Reply-To: <4A734F8A.906@gmx.net>
User-Agent: Mutt/1.5.18 (2008-05-17)


--B2XwZuBUJ8PPSpsy
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Jul 31, 2009 at 10:09:46PM +0200, Andreas wrote:
> Hi,
>
> how can I fetch multiple rows into one text-field?
> I need the contents of some log-infos condensed into a single text to =20
> show in a report.

It sounds like you might want something like this:

SELECT ... array_to_string(array_accum(log_notes, '<some delimiter>')) FROM=
=2E..

You might need to add array_accum manually; before 8.4 it wasn't built in.
See http://www.postgresql.org/docs/8.3/static/xaggr.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--B2XwZuBUJ8PPSpsy
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkpzfl8ACgkQRiRfCGf1UMNXrQCgmgTPn18Xx0BU3ahSExPrK/Zn
9kMAmQFz0mp72c/rJRFIR7VBI/HOMqo5
=eRpL
-----END PGP SIGNATURE-----

--B2XwZuBUJ8PPSpsy--