Overlap function for hstore?

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Overlap function for hstore?
Date: 2015-04-04 00:37:33
Message-ID: CAFcOn29YemqgRRZg7BfO9DriiP7wMaEO=jidSrJJckjEWvBgZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Curvey 2015-04-04 00:57:41 "could not split GIN page; no new items fit"
Previous Message Bill Moran 2015-04-03 22:07:05 Re: Serializable transaction restart/re-execute