|
|
|
[TOC]
|
|
|
|
[[_TOC_]]
|
|
|
|
|
|
|
|
# NULL / NOT NULL
|
|
|
|
|
| ... | ... | @@ -109,3 +109,14 @@ will be translated to |
|
|
|
```
|
|
|
|
|
|
|
|
If a column on a big table is not indexed correctly, this search option will not be allowed.
|
|
|
|
|
|
|
|
# JSONB contains (@>)
|
|
|
|
|
|
|
|
Does the left JSONB value contain the right JSONB path/value entries at the top level?
|
|
|
|
|
|
|
|
```JSON
|
|
|
|
#/data/core/customer/query
|
|
|
|
{
|
|
|
|
"conds" : {"me.phonenumbers" : {"@>" : {"mobile": "+4354359"} },
|
|
|
|
}
|
|
|
|
``` |
