Re: how to list or array of key value pairs

Probably this will help you
http://www.postgresql.org/docs/current/interactive/hstore.html

ps. Look at the each() function.

On 12 October 2011 22:45, J.V. <jvsrvcs(at)gmail(dot)com> wrote:
> I need to rephrase this because of some confusion as to what I was looking
> for.
>
> I want to create and initialize a list or array of key/value pairs.  Then I
> want to iterate through this list (or array) retrieving each key/value for
> use in a sql statement.
>
> I want to do this in a stored function.
>
> that's all
>
> any ideas?
>
> J.V.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray(dot)ru(at)gmail(dot)com / Skype: gray-hemp