On 07/13/2012 02:15 PM, Sergey Konoplev wrote:
On Fri, Jul 13, 2012 at 9:51 AM, Craig Ringer
<craig@xxxxxxxxxxxxxxxxxxxxx> wrote:
... but it feels like there must be a smarter way.
Well, may be kind of (h1 - h2), (h2 - h1) and derivatives will make sense?
I apparently have the reading skills of a stoned mole, as I completely
missed the subtraction operator in hstore's operators table.
"hstore - hstore | delete matching pairs from left operand"
I was thinking in terms of union/intersection/difference, didn't find
matching terms in the hstore docs, and managed to repeatedly overlook
the -(hstore,hstore) operator in the table. Thanks.
On the upside I've come up with the a truly insanely verbose and slow
way to implement the -(hstore,hstore) operator. Yay?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
