[GENERAL] JSONB Overlap Operator.

Поиск
Список
Период
Сортировка
От Eduardo Felipe
Тема [GENERAL] JSONB Overlap Operator.
Дата
Msg-id CAFwyEdF1KZPorUXquEafk8OS7d9fPARKCEQ8=Vh36WrBXKfo7w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] JSONB Overlap Operator.
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] psql - looking in wrong place for socket
Следующее
От: Sridevi B
Дата:
Сообщение: Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data