Postgres Pro
Downloads
Home   >   mailing lists

Re: Overlap function for hstore? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Overlap function for hstore?
Date
Msg-id CAKFQuwa+bR03goUEBrE0c-kkztnQPGkctf3W_f54Nb0bMSi7-Q@mail.gmail.com
Whole thread Raw
In response to Overlap function for hstore?  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: Overlap function for hstore?
List pgsql-general
Tree view
On Fri, Apr 3, 2015 at 5:37 PM, Stefan Keller <sfkeller@gmail.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.

pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: Overlap function for hstore?
Next
From: Tom Lane
Date:
Subject: Re: "could not split GIN page; no new items fit"