| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, cpronovost(at)innvue(dot)com |
| Subject: | Re: Re: BUG #11178: JSONB : The NOT operator applies to the <@ operator, even after casting to ::bool |
| Date: | 2014-08-16 03:52:30 |
| Message-ID: | 31620.1408161150@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> cpronovost wrote
>> When using the <@ operator in conjunction with the NOT operator on a jsonb
>> column, the NOT reverse the <@ operator(becomes a @>).
> The presence of "NOT" does not (aside from a possible bug) change the "<@"
> operator into the "@>" operator. "NOT" simply inverts the supplied boolean
> value so that "not(true) := false" and vice-versa.
That's what it's *supposed* to do, but somebody got the pg_operator entry
wrong. It looks to me like pg_operator OIDs 3246 and 3250 should be
listed as each others' commutators, not each others' negators.
Sigh. So much for no initdb for 9.4beta3. I wonder whether there are
other thinkos in the jsonb operator entries...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-08-16 14:41:50 | Re: Re: BUG #11178: JSONB : The NOT operator applies to the <@ operator, even after casting to ::bool |
| Previous Message | David G Johnston | 2014-08-15 23:59:03 | Re: BUG #11178: JSONB : The NOT operator applies to the <@ operator, even after casting to ::bool |