From: Jan Wieck <JanWieck@Yahoo.com>
To: juerg.rietmann@pup.ch
Cc: pgsql-sql@postgresql.org
Subject: Re: function not running after upgrade from 7.03 to 7.2
Date: Fri, 14 Jun 2002 15:27:48 -0400
Message-ID: <3D0A43B4.FDB814BD@Yahoo.com> (raw)
References: <OF909045EC.749AA2EF-ONC1256BD8.002C2A4D-C1256BD8.002CB715@pup.ch>
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 #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, juerg.rietmann@pup.ch
Subject: Re: function not running after upgrade from 7.03 to 7.2
In-Reply-To: <3D0A43B4.FDB814BD@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox