JSONB Overlap Operator.

[Eduardo Felipe <edufelipe@xxxxxxxxxx>]

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 (&&).

JSONB includes all other operators from arrays, such as containment (@>, <@), comparison (>, >=, <, <=) and inclusion (?). 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