Re: hstore improvements?

>>>>> "David" == "David E Wheeler" <david@kineticode.com> writes:
> On Mar 13, 2009, at 11:06 AM, Andrew Gierth wrote:>> If there's any other features that people find notably missing>>
fromhstore, I could stick them in too; any requests?
 
David> Can you create slices? That is, create a new hstore as aDavid> 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)