On Fri, Apr 3, 2015 at 5:37 PM, Stefan Keller <sfkeller(at)gmail(dot)com> wrote:
> 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?
>
Not tested!
SELECT hstore(array_agg(key), array_agg(value)) FROM (
SELECT each(...)
INTERSECT
SELECT each(...)
) src
David J.