Re: hstore improvements?

On 3/19/09 1:23 PM, Josh Berkus wrote:
> Andrew,
>
>> One request I've had is to construct a record (of some supplied
>> composite type) from an hstore.
>>
>> I'm not sure if this is even possible; I'm certainly not seeing a way
>> to implement it. Am I missing something?
>
> Well, presumably you'd try to match hstore tags against the "columns" of
> the composite type, and where a tag didn't exist, return NULL,and where
> one isn't in the composite type, ignore it. All data would be TEXT.

Oh, and in features I'd want, mostly an UNROLL for hstore ... that is, 
rather than a RECORD, a set of exploded rows.

--Josh