Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] JSONB Overlap Operator. - Mailing list pgsql-general

From Eduardo Felipe
Subject [GENERAL] JSONB Overlap Operator.
Date
Msg-id CAFwyEdF1KZPorUXquEafk8OS7d9fPARKCEQ8=Vh36WrBXKfo7w@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] JSONB Overlap Operator.
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] psql - looking in wrong place for socket
Next
From: Sridevi B
Date:
Subject: Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data