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-----