Re: Proper syntax to update an hstore key-value pair

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Scalia <jayknowsunix(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Proper syntax to update an hstore key-value pair
Date: 2016-08-03 20:40:14
Message-ID: 4736.1470256814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

John Scalia <jayknowsunix(at)gmail(dot)com> writes:
> Sorry if I wasn't clear. Every version I found did include that
> operator, but there were differences in how they were defined. In the 1.1
> version the arguments for "||" were listed as being public.hstore while in
> 1.3 the args were just hstore.

I'm beginning to suspect you have a rogue copy of hstore someplace.
Try "\dT *.hstore" to see if you get more than one hit.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ghiureai 2016-08-03 22:20:06 PG 9.5 same SQL 2 different plans
Previous Message John Scalia 2016-08-03 20:19:40 Re: Proper syntax to update an hstore key-value pair