| 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: | Whole Thread | Raw Message | 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 |