Still don't know how to build this string ?

From: juerg(dot)rietmann(at)pup(dot)ch
To: pgsql-sql(at)postgresql(dot)org
Subject: Still don't know how to build this string ?
Date: 2001-03-26 10:12:54
Message-ID: OFB356DA1B.8A1E6DD6-ONC1256A1B.0037F528@pup.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello there

I have still the same problem. Any help would really be appreciated !
Thanks ... jr

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"

============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-03-26 12:04:41 Re: Functions and Triggers
Previous Message Norbert Schollum 2001-03-26 09:24:32 Functions and Triggers