On Jun 16, 2010, at 4:58 PM, Tom Lane wrote: >> hstore => text[] is new in 9.0. > > Wup, sorry, I read this as being the other operator. Nevermind ... > > (FWIW, I share your dislike of & for this operator. I just haven't > got a better idea.)
There aren't any very good choices. Possible correlates: text[] key_slice := my_hstore -> ARRAY['foo', 'bar']; bool has_keys := my_hstore ?& ARRAY['foo', 'bar']; text[] keyvals := %% my_hstore; text[] keyvals := %# my_hstore; Frankly, %% and %# are closest, in a sense. But instead of an array, we want to get back an hstore. -> and ?& are correlates in that their RHSs are arrays. Possible operators to get a slice of the hstore: hstore slice := my_hstore +> ARRAY['foo', 'bar']; hstore slice := my_hstore #> ARRAY['foo', 'bar']; hstore slice := my_hstore &> ARRAY['foo', 'bar']; hstore slice := my_hstore !> ARRAY['foo', 'bar']; hstore slice := my_hstore *> ARRAY['foo', 'bar']; hstore slice := my_hstore %> ARRAY['foo', 'bar']; hstore slice := my_hstore @ ARRAY['foo', 'bar']; hstore slice := my_hstore % ARRAY['foo', 'bar']; hstore slice := my_hstore # ARRAY['foo', 'bar']; hstore slice := my_hstore & ARRAY['foo', 'bar']; hstore slice := my_hstore @# ARRAY['foo', 'bar']; Maybe %> is good, in that it combines %% and ->, in a sense. Or #>, which kind of goes along with #=, which also returns an hstore. Anyway, the more I look at it the less I care, as long as *something* works. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
