juerg(dot)rietmann(at)pup(dot)ch writes:
> Except the following function/view is not working. I get an error, saying :
> Missing LOOP at end of SQL expression
> FOR rec IN SELECT z_u_umfang FROM zylinder_umfang WHERE z_u_typ = $1;
> list := list || text(rec.z_u_umfang) || '','';
> END LOOP;
Should be
FOR record | row IN select_query LOOP
statements
END LOOP;
(copied and pasted from the plpgsql documentation...)
regards, tom lane