Re: how to key/value iterate in stored function
От | J.V. |
---|---|
Тема | Re: how to key/value iterate in stored function |
Дата | |
Msg-id | 4E95FF2A.1080603@gmail.com обсуждение исходный текст |
Ответ на | Re: how to key/value iterate in stored function (David Johnston <polobo@yahoo.com>) |
Список | pgsql-general |
I tried that, but it did not work. what i am looking for is a means to iterate over an array or list fetching both the key and the value. if you have such an example, it would be appreciated. > >Create a custom type with two text components and use that in an array. > >David J. On 10/12/2011 1:11 PM, David Johnston wrote: > > On Oct 12, 2011, at 14:43, "J.V."<jvsrvcs@gmail.com> wrote: > >> 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@gmail.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 >>> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > Create a custom type with two text components and use that in an array. > > David J.
В списке pgsql-general по дате отправления: