Function not running after upgrade 7.03 to 7.2

Поиск
Список
Период
Сортировка
От juerg.rietmann@pup.ch
Тема Function not running after upgrade 7.03 to 7.2
Дата
Msg-id OFEF84282A.60BE7889-ONC1256BD8.002CE03F-C1256BD8.002D075F@pup.ch
обсуждение исходный текст
Ответы Re: Function not running after upgrade 7.03 to 7.2  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-sql
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
__________________________________________________




В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: simple recursive function in plpgsql fails
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Function not running after upgrade 7.03 to 7.2