From: John Scalia <jayknowsunix@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
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> (raw)
In-Reply-To: <16363.1470253775@sss.pgh.pa.us>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 going to revisit my tests tomorrow morning. I've gotten all my versions now at 1.3, but it's been a very long day since I started 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:
>
> 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 schema.
>> My search path does include that.
>
> Hmm. AFAICS, every extant version of hstore ought to provide
>
> operator ||(hstore,hstore)
>
> and no other operator named ||. You might try comparing the results
> of "\dx+ hstore" across your installations.
>
> regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Proper syntax to update an hstore key-value pair
In-Reply-To: <EE53D6C9-60D3-49ED-9F5B-76D9AB90F17A@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox