jsonb inequality operators

Started by Andrew Dunstanover 11 years ago3 messages
#1Andrew Dunstan
andrew@dunslane.net

I have just noticed as I am preparing my slides well ahead of time :-)
that we haven't documented the inequality operators of jsonb. Is that
deliberate or an oversight?

cheers

andrew

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

#2David E. Wheeler
david@justatheory.com
In reply to: Andrew Dunstan (#1)
Re: jsonb inequality operators

On May 20, 2014, at 4:39 PM, Andrew Dunstan <andrew@dunslane.net> wrote:

I have just noticed as I am preparing my slides well ahead of time :-) that we haven't documented the inequality operators of jsonb. Is that deliberate or an oversight?

That’s gotta be an oversight. The hash and btree index support is documented, which implies those operators, yes?

David

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: David E. Wheeler (#2)
Re: jsonb inequality operators

"David E. Wheeler" <david@justatheory.com> writes:

On May 20, 2014, at 4:39 PM, Andrew Dunstan <andrew@dunslane.net> wrote:

I have just noticed as I am preparing my slides well ahead of time :-) that we haven't documented the inequality operators of jsonb. Is that deliberate or an oversight?

That’s gotta be an oversight. The hash and btree index support is documented, which implies those operators, yes?

Those opclasses don't actually *require* any inequality operator --- but
a quick look in the catalogs says there is one. So yeah, an oversight.

regards, tom lane

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