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
