Overlap function for hstore? - Mailing list pgsql-general

From Stefan Keller
Subject Overlap function for hstore?
Date
Msg-id CAFcOn29YemqgRRZg7BfO9DriiP7wMaEO=jidSrJJckjEWvBgZQ@mail.gmail.com
Whole thread Raw
Responses Re: Overlap function for hstore?  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Re: Overlap function for hstore?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Hi,

I'd like to get an overlap function similar to '&&' but for key-value
pairs of hstore!

This underfits:

postgres=# select hstore_to_array('a=>1,b=>2,c=>3'::hstore) &&
hstore_to_array('a=>2,d=>4,b=>2'::hstore)

...because array overlaps op takes every element (even 'a' or 2 alone)
and doesn't test for key and value together like in 'b=>2'!

Any clever ideas?

Yours, Stefan


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Serializable transaction restart/re-execute
Next
From: Chris Curvey
Date:
Subject: "could not split GIN page; no new items fit"