Ben <bench@silentmedia.com> writes:
> On Sat, 2003-11-22 at 12:44, CSN wrote:
>> Is it possible to iterate over an array in plpgsql?
> Yep.
> http://archives.postgresql.org/pgsql-general/2003-11/msg00852.php
The cited example is pretty iffy since it assumes that the valid array
entries are all > 0. In recent PG version you can use the array_upper
and array_lower functions instead:
for i in array_lower(a,1) .. array_upper(a,1) loop
-- do something with a[i]
end loop;
regards, tom lane