Iterate over an array in stored procedure - Mailing list pgsql-general

From Henrik Zagerholm
Subject Iterate over an array in stored procedure
Date
Msg-id 0FDBA12E-4E89-4878-B648-DBE91829D28A@mac.se
Whole thread Raw
Responses Re: Iterate over an array in stored procedure
List pgsql-general
Hello,

I wonder how I can iterate over a sql array in a pl/perl function.

I want to pass in an text[] to a function and then iterate through
the values and run it through a perl sprintf but I can't seem to get
it to work.

Should I do a generate_series and make an internal perl array?
If so how would I do this?

Regards,
Henrik

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Excell
Next
From: "Rhys Stewart"
Date:
Subject: regexp searching in arrays not working?