| From: | Eduardo Felipe <edufelipe(at)e3c(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | JSONB Overlap Operator. |
| Date: | 2017-03-17 14:43:18 |
| Message-ID: | CAFwyEdF1KZPorUXquEafk8OS7d9fPARKCEQ8=Vh36WrBXKfo7w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 (&&)
<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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sridevi B | 2017-03-17 16:54:25 | Re: pg_dump pg_restore hanging in CentOS for large data |
| Previous Message | Adrian Klaver | 2017-03-17 14:39:09 | Re: psql - looking in wrong place for socket |