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

From Paul Jungwirth
Subject Re: Overlap function for hstore?
Date
Msg-id 551F382F.6090703@illuminatedcomputing.com
Whole thread Raw
In response to Overlap function for hstore?  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-general
 > 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'!

How about hstore_to_matrix? Then you have a tuple for each key/value pair.

Paul




pgsql-general by date:

Previous
From: Chris Curvey
Date:
Subject: "could not split GIN page; no new items fit"
Next
From: "David G. Johnston"
Date:
Subject: Re: Overlap function for hstore?