Re: How to loop though an array plpgsql? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: How to loop though an array plpgsql?
Date
Msg-id 20050730131505.GA65221@winnie.fuhr.org
Whole thread Raw
In response to How to loop though an array plpgsql?  (Matthew Schumacher <matt.s@aptalaska.net>)
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: bug in information_schema?
Next
From: Tom Lane
Date:
Subject: Re: bug in information_schema?