Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
From: John Scalia <jayknowsunix@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Proper syntax to update an hstore key-value pair
Date: Wed, 3 Aug 2016 15:19:40 -0500
Message-Id: <EE53D6C9-60D3-49ED-9F5B-76D9AB90F17A@gmail.com>
References: 
 <CABzCKRBa6859u6NEcmyddc0iknoMbmMao4AAVpTUS4i464J0uA@mail.gmail.com>
 <22859.1470234864@sss.pgh.pa.us>
 <CABzCKRBdeQ-D5KQnHtu5tjMBNfhr4NMr-f3ZUQs6fpcsiGLhAA@mail.gmail.com>
 <28358.1470242851@sss.pgh.pa.us>
 <CABzCKRBgmOY8Jx6wfuxnntUvr4JZu02sJBgG9-UOLCqWV=WktQ@mail.gmail.com>
 <32215.1470245101@sss.pgh.pa.us>
 <CABzCKRCJr3FbajAafcjw=XibOFZ6PAw57YfcenC+9ypYpLezxQ@mail.gmail.com>
 <16363.1470253775@sss.pgh.pa.us>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <16363.1470253775@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Sorry if I wasn't clear. Every version I found did include that operator, b=
ut 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 going to revisit my tests tomorrow morning. I've got=
ten all my versions now at 1.3, but it's been a very long day since I start=
ed at 6:30 am this morning.

Thanks for your help, everyone.

Sent from my iPad

> On Aug 3, 2016, at 2:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> John Scalia <jayknowsunix@gmail.com> writes:
>> Well, I discovered that I had different versions of hstore across several
>> databases. Some were 1.1 and others were 1.3. On the 1.3 hstore versions,
>> the \do *.|| produces a public hstore - hstore operator, while the 1.1
>> shows the same as public.hstore. Maybe I just wasn't casting this far
>> enough. On both versions that operator shows as being in the public sche=
ma.
>> My search path does include that.
>=20
> Hmm.  AFAICS, every extant version of hstore ought to provide
>=20
> operator ||(hstore,hstore)
>=20
> and no other operator named ||.  You might try comparing the results
> of "\dx+ hstore" across your installations.
>=20
>            regards, tom lane


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin