Re: hstore improvements?

Hi,

Le 19 mars 09 à 21:23, Josh Berkus a écrit :
>> 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.

The problem is more how to have the parser know which data type to
target, because you want to avoid having to create a new cast per each
composite type you want to target.

A solution could maybe look like this:
SELECT hstore_to_composite(hstore_value, null::my_composite_type);

Regards,
--
dim

from the IRC-to-List bridge dept ;)