pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Eckermann <jeckermann@verio.net>
To: 'juerg.rietmann@pup.ch' <juerg.rietmann@pup.ch>
To: pgsql-sql@postgresql.org
Subject: RE: Still don't know how to build this string ?
Date: Mon, 26 Mar 2001 11:02:29 -0600
Message-ID: <08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU> (raw)

Still learning this stuff, so please be gentle...


jeff=# select * from test_it;
 typ | diam 
-----+------
 01  | 800
 01  | 840
 01  | 870
 01  | 1120
 02  | 760
 02  | 780
 02  | 800
 02  | 900
 03  | 1200
 03  | 1234
 03  | 1352
(11 rows)

jeff=# \! cat test_it
drop function test_it_too(text);
create function test_it_too(text)
returns text as '
declare 
typ2 alias for $1;
rec record;
string text:= '''';
begin
for rec in select * from test_it where typ = typ2 loop
string := string || rec.diam || '','';
end loop;
string := substr(string, 1, length(string)-1);
return string;
end;
' language 'plpgsql';

jeff=# \i test_it
DROP
CREATE
jeff=# select test_it_too('01');
   test_it_too    
------------------
 800,840,870,1120
(1 row)



> -----Original Message-----
> From:	juerg.rietmann@pup.ch [SMTP:juerg.rietmann@pup.ch]
> Sent:	Monday, March 26, 2001 4:13 AM
> To:	pgsql-sql@postgresql.org
> Subject:	Still don't know how to build this string ?
> 
> 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
> ============================================
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl



view thread (9+ messages)  latest in thread

Message-ID: <08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU>
Permalink:  ../08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU/
Also on:    postgresql.org/message-id/08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jeckermann@verio.net, juerg.rietmann@pup.ch
  Subject: Re: Still don't know how to build this string ?
  In-Reply-To: <08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU>
  References: <08CD1781F85AD4118E0800A0C9B8580B0949D7@NEZU>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox