Re: array iteration?

Hey, that's cool. When did those functions arrive?

On Sun, 23 Nov 2003, Tom Lane wrote:

> Ben  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
>