How to dereference 2 dimensional array?

From: ChoonSoo Park <luispark(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to dereference 2 dimensional array?
Date: 2012-02-16 15:48:58
Message-ID: CACgbiFt=S+bScUv3OLXhVeToWrGcjJ74vYZ85tqW9X6g0-OPSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Musial, Jan (GIUB) 2012-02-16 16:45:49 Re: Dynamic update of a date field
Previous Message Vojtěch Rylko 2012-02-16 14:56:13 Re: Drop big index