Re: a set of key/value pairs

On Thu, Oct 20, 2011 at 1:53 PM, J.V. <jvsrvcs(at)gmail(dot)com> wrote:
> Does anyone have a specific example of how to:
>    1) create a variable that is a set or array of key value pairs?
>    2) how to populate each element of the array (each element being a key /
> value pair)
>    3) how to iterate through the list or array retrieving each key/value
> pair?

create type pair_t as (key text, value text);

select array[('a', '123'), ('b', '234')]::pair_t[];

select (unnest(array[('a', '123'), ('b', '234')]:: pair_t[])).*;

merlin