Hey, that's cool. When did those functions arrive?
On Sun, 23 Nov 2003, Tom Lane wrote:
> Ben <bench(at)silentmedia(dot)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
>