[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
