Re: [SQL] Function not running after upgrade 7.03 to 7.2

2002-06-14 Thread Christopher Kings-Lynne
> Query : > > SELECT *, > (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang > FROM zylinder; > > Thank's in advance for any help jr Try this: SELECT *, (SELECT rtrim("buildUmfang"(zylinder.z_typ), ','::text) AS rtrim) AS umfang FROM zylinder; I think it's because yo

[SQL] Function not running after upgrade 7.03 to 7.2

2002-06-14 Thread juerg . rietmann
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;