function not running after upgrade from 7.03 to 7.2

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
__________________________________________________

Responses

Browse pgsql-sql by date

  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