Skip to content

Instantly share code, notes, and snippets.

@jibrel

jibrel/hge_jsonb_boolean_operators.md

Forked from shahidhk/hge_jsonb_boolean_operators.md
Created August 3, 2021 22:48
Show Gist options
  • Save jibrel/de265a033037ce490ff7f3c7952ab906 to your computer and use it in GitHub Desktop.
Save jibrel/de265a033037ce490ff7f3c7952ab906 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hge_jsonb_boolean_operators.md
Operator Postgres equivalent Description
_contains @> Does the column value contains these key-value pairs at top-level?
_contained_in <@ Is the column value contained in this JSON object at top-level?
_has_key ? Does the string exist as a top-level key within the JSON value?
_has_keys_any ?| Do any of these array strings exist as top-level keys?
_has_keys_all ?& Do all of these array strings exist as top-level keys?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment