Hi there!

In a project I was experimenting with replacing array columns with JSONB
columns, to allow a greater flexibility of types.

One thing that I found missing is the "overlap" operator (&&)
<https://www.postgresql.org/docs/9.6/static/functions-array.html>.

JSONB includes all other operators from arrays, such as containment (@>,
<@), comparison (>, >=, <, <=) and inclusion (?)
<https://www.postgresql.org/docs/9.6/static/functions-json.html>. The only
one missing is the overlap operator (&&).

Does anyone know of a technical reason that operator was not included on
JSONB?

Best regards,

Eduardo Felipe.
E3C Tecnologia

Reply via email to