Received: from srvlnx02.pup.ch ([195.15.182.63]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2ME3Jt64949 for ; Thu, 22 Mar 2001 09:03:19 -0500 (EST) (envelope-from juerg.rietmann@pup.ch) Subject: how to build this string ? To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: juerg.rietmann@pup.ch Date: Thu, 22 Mar 2001 15:05:51 +0100 X-MIMETrack: Serialize by Router on srvlnx02/Pup/ch(Release 5.0.5 |September 22, 2000) at 03/22/2001 03:05:57 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200103/444 X-Sequence-Number: 2112 Hello there Is it possible (and I think it is) to do the following : I have a table with diameters and types. I need to build a comma separated string. typ diam 01 800 01 840 01 870 01 1120 02 760 02 780 02 800 02 900 03 1200 03 1234 03 1352 select diam from zylinder where typ='01' should produce the string "800,840,870,1120" Thanks for any help ... jr ============================================ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ============================================