problem with view/function after upgrade to 7.2
От | juerg.rietmann@pup.ch |
---|---|
Тема | problem with view/function after upgrade to 7.2 |
Дата | |
Msg-id | OF4B75D79A.D0042C31-ONC1256B5E.002ACC54@pup.ch обсуждение исходный текст |
Ответы |
Re: problem with view/function after upgrade to 7.2
|
Список | pgsql-admin |
Hello there After upgrading from 7.0.3 to 7.2 almost everything is up and running ! Except the following function/view is not working. I get an error, saying : Missing LOOP at end of SQL expression What has changed here ? Thanks for any help !! Regards ... jr CREATE FUNCTION buildString(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; list := list || text(rec.z_u_umfang) || '',''; END LOOP; RETURN list; END;' LANGUAGE 'plpgsql'; CREATE VIEW "viewrzumfang" AS SELECT rotation.r_code, rotation.r_name, rotation.r_z_typ, (SELECT zylinder_typen.z_laenge FROM zylinder_typen WHERE (zylinder_typen.z_typ = rotation.r_z_typ)) AS r_z_laenge, (SELECT zylinder_typen.z_blaenge FROM zylinder_typen WHERE (zylinder_typen.z_typ = rotation.r_z_typ)) AS r_z_blaenge, (SELECT zylinder_typen.z_alaenge_l FROM zylinder_typen WHERE (zylinder_typen.z_typ = rotation.r_z_typ)) AS r_z_alaenge_l, (SELECT zylinder_typen.z_alaenge_r FROM zylinder_typen WHERE (zylinder_typen.z_typ = rotation.r_z_typ)) AS r_z_alaenge_r, (SELECT rtrim(buildstring(rotation.r_z_typ), ','::text) AS rtrim) AS r_z_umfang FROM rotation; __________________________________________________ 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 __________________________________________________
В списке pgsql-admin по дате отправления: