Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2RDQQw93411 for ; Tue, 27 Mar 2001 08:26:26 -0500 (EST) (envelope-from lbc@telecam.demon.co.uk) Received: from telecam.demon.co.uk ([194.222.201.144] helo=linux.telecam) by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1) id 14htUM-000CyI-0A; Tue, 27 Mar 2001 13:26:22 +0000 Received: from andy.telecam (andy.telecam [10.0.0.2]) by linux.telecam (8.9.3/8.8.7) with ESMTP id OAA29254; Tue, 27 Mar 2001 14:22:05 +0100 Date: Tue, 27 Mar 2001 15:22:37 +0100 From: Andy Corteen X-Mailer: The Bat! (v1.49) Business Reply-To: Andy Corteen Organization: Telecam Electronics Ltd X-Priority: 3 (Normal) Message-ID: <14918780083.20010327152237@telecam.demon.co.uk> To: juerg.rietmann@pup.ch CC: pgsql-sql@postgresql.org Subject: Re: Re: Still don't know how to build this string ? how to concat ?? In-reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/550 X-Sequence-Number: 2220 Tuesday, March 27, 2001, 10:20:18 AM, you wrote: jrpc> jrpc> Result: jrpc> 01 1440 jrpc> 02 1460 jrpc> 03 1398 jrpc> The values (1440, ...) are the last entries of z_u_umfang for each z_u_typ. jrpc> This is correct since in the function the list:= ... is overwritten until jrpc> the last record is read. jrpc> When I try to concat the list in the manner of list := list || jrpc> text(rec.z_u_umfang); the zustring is empty ! jrpc> Thanks for any help ... jr jrpc> Query : jrpc> select distinct z_u_typ, buildString(z_u_typ) as zustring from jrpc> zylinder_umfang jrpc> Function: jrpc> CREATE FUNCTION buildString(bpchar) RETURNS text AS ' jrpc> DECLARE jrpc> list text; jrpc> rec record; jrpc> BEGIN jrpc> FOR rec IN SELECT z_u_umfang FROM zylinder_umfang WHERE z_u_typ jrpc> = $1; jrpc> list := text(rec.z_u_umfang); jrpc> END LOOP; jrpc> RETURN list; jrpc> END; jrpc> ' LANGUAGE 'plpgsql'; You seem to be constantly re-assigning "list", rather than adding to it with each iteration of the "for loop". Would: ... list := list || ',' || text(rec.z_u_umfang) ... be what your solution is missing? -- Best regards, Andy mailto:lbc@telecam.demon.co.uk