Re: how to list or array of key value pairs

On Fri, Oct 14, 2011 at 3:22 PM, J.V. <jvsrvcs@gmail.com> wrote:
> Yes, I have seen this before.
>
> But I need an array of key/value pairs (key is string, value is string) and
> I need to iterate through the array accessing both the key and the value.
>
> I look at this page and it does not translate very well into what I need to
> do.  If there are any specific examples out there, it would be greatly
> appreciated.

you keep getting the same answer because as you described your problem
it does *exactly* what you want to do.  so, either you are not
describing the problem well or you are not understanding us:
postgres=# select * from each('a=>1,b=>2');
 key | value
-----+-------
 a   | 1
 b   | 2
(2 rows)

can be dropped directly into plgsql

for record_variable in select * from each('a=>1,b=>2')
loop
  <do stuff>
end loop;

etc.  What's the issue?

merlin