| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: hstore improvements? |
| Date: | 2009-03-19 20:26:47 |
| Message-ID: | 49C2AA87.5030701@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-03-19 20:36:27 | Re: Extension of Thick Indexes |
| Previous Message | Josh Berkus | 2009-03-19 20:23:57 | Re: hstore improvements? |