From: | juerg(dot)rietmann(at)pup(dot)ch |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | function not running after upgrade from 7.03 to 7.2 |
Date: | 2002-06-14 08:08:03 |
Message-ID: | OF909045EC.749AA2EF-ONC1256BD8.002C2A4D-C1256BD8.002CB715@pup.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
__________________________________________________
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
__________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | juerg.rietmann | 2002-06-14 08:11:28 | Function not running after upgrade 7.03 to 7.2 |
Previous Message | Tom Lane | 2002-06-14 05:02:20 | Re: simple recursive function in plpgsql fails |