From: | "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com> |
---|---|
To: | |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to key/value iterate in stored function |
Date: | 2011-10-12 18:43:06 |
Message-ID: | 4E95DFBA.1090304@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I tried hstore with no luck.
How do I initialize the array?
How do I loop through each key/value pair in a stored function to
retrieve the key and value for each item in the list?
I need a list of key value pairs. Any options there?
J.V.
On 10/12/2011 8:51 AM, Merlin Moncure wrote:
> On Wed, Oct 12, 2011 at 8:46 AM, J.V.<jvsrvcs(at)gmail(dot)com> wrote:
>> I want to create a variable that is an array or list of key/value pairs.
>>
>> The key would be a table name and the value would be a sql statement or a
>> value or list of values for which I could extract to create a sql statement
>> and execute.
>>
>> I have tried experimenting with various arrays, but there is no clear
>> example or documentation. The key and the value would be text.
>>
>> I want to iterate over the entire array (or list), so would need an example
>> on that or some pointers there, if there is help.
> use thee the hstore!
>
> postgres=# select * from each('a=>1,b=>2');
> key | value
> -----+-------
> a | 1
> b | 2
> (2 rows)
>
> (if you do stick with arrays, use unnest() -- it can be built for
> older versions if you don't have it).
>
> merlin
>
From | Date | Subject | |
---|---|---|---|
Next Message | J.V. | 2011-10-12 18:45:15 | how to list or array of key value pairs |
Previous Message | René Fournier | 2011-10-12 18:01:48 | PostGIS: Approximating a house number from street address range |