Plpgsql: Iterating through a string of parameters

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: postgresql <pgsql-sql(at)postgresql(dot)org>
Subject: Plpgsql: Iterating through a string of parameters
Date: 2010-03-25 15:16:53
Message-ID: 201003251616.53097.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm struggling with how to make plpgsql iterate through a list of numbers
input as a text string, eg. "1438 2656 973 4208". I figure that I can use the
regexp_split_to_array() function to make an array of the string, but can I
iterate through an array with eg. a FOR loop?

regards,
--
Leif Biberg Kristensen
http://solumslekt.org/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Leif Biberg Kristensen 2010-03-25 16:00:25 Re: Plpgsql: Iterating through a string of parameters
Previous Message Tom Lane 2010-03-25 14:35:26 Re: Does IMMUTABLE property propagate?