Hi all,
I'm observing that this piece of code doesn't work
anymore in postgres 8.0

DECLARE
quota RECORD;
BEGIN
FOR quota IN
SELECT quota
FROM foo
LOOP
....
END LOOP;
....

the table foo have the field quota

The error reported is:

ERROR: record "quota" is not assigned yet
DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.

and is clear to me why. Shall not this be inserted in the release note ?



Regards
Gaetano Mendola






---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match