Re: How to loop though an array plpgsql?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to loop though an array plpgsql?
Date: 2005-07-30 13:15:05
Message-ID: 20050730131505.GA65221@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-07-30 15:15:12 Re: bug in information_schema?
Previous Message Kyle Bateman 2005-07-30 04:50:08 bug in information_schema?