Re: hstore improvements?

>>>>> "David" == "David E Wheeler" <david(at)kineticode(dot)com> writes:

> On Mar 13, 2009, at 11:06 AM, Andrew Gierth wrote:
>> If there's any other features that people find notably missing
>> from hstore, I could stick them in too; any requests?

David> Can you create slices? That is, create a new hstore as a
David> subset of an existing hstore?

ooh. good point. What would be a good operator for that?

I'm thinking that (hstore -> text[]) should probably return text[],
and maybe (hstore => text[]) returning hstore?

i.e.

select ('a=>1,b=>2,c=>3'::hstore) -> ARRAY['a','b'];
-- returns '{1,2}'

select ('a=>1,b=>2,c=>3'::hstore) => ARRAY['a','b'];
-- returns 'a=>1,b=>2'

(by analogy to the existing operators -> for lookup and => for
construction)

--
Andrew (irc:RhodiumToad)