Thread: a set of key/value pairs

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?

Please do not point me to this doc:
     http://developer.postgresql.org/pgdocs/postgres/hstore.html

What I am looking for is an example as listed in 1..3 above, and that is
not provided in the doc.

Regards,


J.V.

On 10/20/11 11:53 AM, J.V. 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?

in what programming language?     in SQL, there aren't 'variables',
there are relations, and you don't 'iterate', you query.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

On Thu, Oct 20, 2011 at 1:53 PM, J.V. <jvsrvcs@gmail.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