Re: function not running after upgrade from 7.03 to 7.2

juerg(dot)rietmann(at)pup(dot)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(at)postgresql(dot)org

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #