Re: function not running after upgrade from 7.03 to 7.2

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(<that_damned_type>) 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 #