Re: [GENERAL] how to list or array of key value pairs

2011-10-14 Thread Merlin Moncure
On Fri, Oct 14, 2011 at 3:22 PM, J.V. 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

Re: [GENERAL] how to list or array of key value pairs

2011-10-14 Thread J.V.
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 examp

Re: [GENERAL] how to list or array of key value pairs

2011-10-13 Thread Sergey Konoplev
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. 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 arra

[GENERAL] how to list or array of key value pairs

2011-10-12 Thread J.V.
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 functio