Re: how to list or array of key value pairs - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: how to list or array of key value pairs
Date
Msg-id CAL_0b1siJrBhuH98x8YEQAgNawWA41R-hfWOyqo2_-DHARJbLA@mail.gmail.com
Whole thread Raw
In response to how to list or array of key value pairs  ("J.V." <jvsrvcs@gmail.com>)
Responses Re: how to list or array of key value pairs  ("J.V." <jvsrvcs@gmail.com>)
List pgsql-general
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@gmail.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@postgresql.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.ru@gmail.com / Skype: gray-hemp

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Dynamic sql real examples
Next
From: "Albe Laurenz"
Date:
Subject: Re: Are file system level differential/incremental backups possible?