Re: How to loop though an array plpgsql?

On Fri, Jul 29, 2005 at 03:39:12PM -0800, Matthew Schumacher wrote:
> I need to loop though an input array, but can't figure out how to do it,
> the docs aren't really clear on this.

This comes up from time to time -- search the archives to see past
discussion.  Suggestions usually involve array_lower() and array_upper().

http://archives.postgresql.org/
http://www.postgresql.org/docs/8.0/static/functions-array.html

If you're using integers then see also the int_array_enum() function
in the contrib/intagg module.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/