pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedfunction not running after upgrade from 7.03 to 7.2
2+ messages / 2 participants
[nested] [flat]
* function not running after upgrade from 7.03 to 7.2
@ 2002-06-14 08:08 juerg.rietmann@pup.ch
2002-06-14 19:27 ` Re: function not running after upgrade from 7.03 to 7.2 Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: juerg.rietmann@pup.ch @ 2002-06-14 08:08 UTC (permalink / raw)
To: 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
__________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: function not running after upgrade from 7.03 to 7.2
2002-06-14 08:08 function not running after upgrade from 7.03 to 7.2 juerg.rietmann@pup.ch
@ 2002-06-14 19:27 ` Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jan Wieck @ 2002-06-14 19:27 UTC (permalink / raw)
To: juerg.rietmann@pup.ch; +Cc: pgsql-sql
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 #
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-06-14 19:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-14 08:08 function not running after upgrade from 7.03 to 7.2 juerg.rietmann@pup.ch
2002-06-14 19:27 ` Jan Wieck <JanWieck@Yahoo.com>
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