Re: Combining several rows [solved]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thanks a lot Holger your aggregate function is the perfect solution to my
problem.

yours
Matthias Nagl

Am Monday 24 May 2004 15:40 schrieb Holger Klawitter:
> Hi,
>
> > I would like to combine the contents of several rows of a subquery. After
> > several hours of search in the documentation and the internet I didn'T
> > find a solution and hope anyone can help. My problem:
>
> You have to create your own aggreate.
> You can use this one:
>
> ---------------------------------------------------
> CREATE OR REPLACE FUNCTION
> join_sep ( text, text, text )
> RETURNS text
> LANGUAGE 'sql'
> IMMUTABLE
> AS '
> SELECT CASE
> WHEN $1 IS NULL THEN $3
> ELSE $1 || $2 || $3
> END;
> ';
> ---------------------------------------------------
> CREATE OR REPLACE FUNCTION
> join_text ( text, text )
> RETURNS text
> LANGUAGE 'sql'
> AS '
> SELECT join_sep($1,'', '',$2);
> ';
> ---------------------------------------------------
> CREATE AGGREGATE join (
> BASETYPE = text,
> SFUNC = join_text,
> STYPE = text
> );
>
> Mit freundlichem Gruß / With kind regards
> Holger Klawitter
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAsnDLfg4gS83RRywRAmzWAJ9gzOVDbKsyjxB6tu08lDp6A+bT9wCfZ5QG
HOB3GYN85ldJJcvdH6W5F7I=
=Yw/g
-----END PGP SIGNATURE-----