How to dereference 2 dimensional array?

Поиск
Список
Период
Сортировка
Искать
От
ChoonSoo Park
Тема
How to dereference 2 dimensional array?
Дата
Msg-id
CACgbiFt=S+bScUv3OLXhVeToWrGcjJ74vYZ85tqW9X6g0-OPSg@mail.gmail.com
Список
Дерево обсуждения
How to dereference 2 dimensional array? ChoonSoo Park <luispark@gmail.com>
Re: How to dereference 2 dimensional array? Bartosz Dmytrak <bdmytrak@eranet.pl>
Re: How to dereference 2 dimensional array? Merlin Moncure <mmoncure@gmail.com>

I would like to construct hstore array from 2 dimensional array.


For example, 


'{{f1, 1, f2, 123, f3, ABC, ...}, {f1, 2, f2, 345, f3, DEF, ...}}'


Should be converted to


2 hstore values

"f1"=>"1", "f2"=>"123", "f3"=>"ABC", ...

"f2"=>"2", "f2"=>"345", "f3"=>"DEF", ...


create or replace function convertHStore(p1 text[][]) RETURNS hstore[]


hstore function requires text[] to convert array to hstore. Therefore I should be able to dereference 2 dimensional array element.

Inside this custom plpgsql function, p1[1] is not valid syntax to dereference the 1st element in p1.


Anyone knows how to solve this problem?


Thank you,

Choon Park 

В списке pgsql-general по дате отправления
От: Vojtěch Rylko
Дата:
Сообщение: Re: Drop big index
От: Musial, Jan (GIUB)
Дата:
FAQ