Iterate over an array in stored procedure

From: Henrik Zagerholm <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Iterate over an array in stored procedure
Date: 2007-06-19 22:13:26
Message-ID: 0FDBA12E-4E89-4878-B648-DBE91829D28A@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nhrcommu 2007-06-19 22:13:29 Re: Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage
Previous Message Joshua D. Drake 2007-06-19 21:27:04 Re: Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage