Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 59D2D4776A2 for ; Fri, 14 Jun 2002 16:07:19 -0400 (EDT) Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (Postfix) with SMTP id 5D21F4774BA for ; Fri, 14 Jun 2002 15:28:21 -0400 (EDT) Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with plain) by smtp.mail.vip.sc5.yahoo.com with SMTP; 14 Jun 2002 19:28:22 -0000 Message-ID: <3D0A43B4.FDB814BD@Yahoo.com> Date: Fri, 14 Jun 2002 15:27:48 -0400 From: Jan Wieck X-Mailer: Mozilla 4.79 [en] (X11; U; Linux 2.2.14-6.1.1smp i686) X-Accept-Language: en MIME-Version: 1.0 To: juerg.rietmann@pup.ch Cc: pgsql-sql@postgresql.org Subject: Re: function not running after upgrade from 7.03 to 7.2 References: Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200206/212 X-Sequence-Number: 8177 juerg.rietmann@pup.ch wrote: > > Hello > > I have three functions running under 7.03, Now, after the Upgrade to 7.2 > these functions are not working. > What has changed in version 7.2 that causes this problem. > > Function : > > CREATE FUNCTION "buildUmfang"("bpchar") RETURNS "text" AS 'DECLARE > list text; > rec record; > BEGIN > list := ''''; > FOR rec IN SELECT z_u_umfang FROM zylinder_umfang WHERE z_u_typ = $1 > LOOP > list := list || text(rec.z_u_umfang) || '',''; > END LOOP; > RETURN list; > END; > > ' LANGUAGE 'plpgsql'; > COMMENT ON FUNCTION "buildUmfang"("bpchar") IS 'Diese Funktion generiert > einen String mit allen Umfängen zum übergebenen Zylindertyp\n\n'; > > Query : > > SELECT *, > (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang > FROM zylinder; > > Thank's in advance for any help .... jr Without telling us at least the error message, or beeing a little more precise what you consider "not working", it's just guessing. What type is zylinder_umfang.z_u_umfang? Maybe the casting to text doesn't work because the function text() is gone. Jan > > __________________________________________________ > > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > Juerg Rietmann > Grundstrasse 22a > 6343 Rotkreuz > Switzerland > > internet : www.pup.ch > phone : +4141 790 4040 > fax : +4141 790 2545 > mobile : +4179 211 0315 > __________________________________________________ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #