Created
July 30, 2020 15:15
-
-
Save mufti1/d7f44764f8747535d8fbc14ff54b8bc0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
╔══════════╦═══════════════════╦══════════════════════════════════════════════════════════════════════════╦════════════════════════╦════════════════════════════════════╦════════════════════════╗ | |
║ Operator ║ Tipe Data Operand ║ Deskripsi ║ Contoh Data ║ Contoh penggunaan Operator ║ Hasil ║ | |
╠══════════╬═══════════════════╬══════════════════════════════════════════════════════════════════════════╬════════════════════════╬════════════════════════════════════╬════════════════════════╣ | |
║ @> ║ jsonb ║ Apakah nilai x ada di data JSON? ║ {"a":1, "b":2}' ║ ::jsonb @> '{"b":2}'::jsonb ║ {"a":1, "b":2}' ║ | |
║ <@ ║ jsonb ║ Apakah nilai data JSON mengandung nilai x ? ║ {"b":2}' ║ ::jsonb <@ '{"a":1, "b":2}'::jsonb ║ {"b":2}' ║ | |
║ ? ║ text ║ Apakah key teratas data mengandung key x? ║ {"a":1, "b":2}' ║ ::jsonb ? 'b' ║ {"a":1, "b":2}' ║ | |
║ ?| ║ text[] ║ Apakah key teratas data mengandung setidaknya salah satu dari array of x ║ {"a":1, "b":2, "c":3}' ║ ::jsonb ?| array['b', 'c'] ║ {"a":1, "b":2, "c":3}' ║ | |
║ ?& ║ text[] ║ Apakah key teratas data mengandung semua nilai dari array of x ║ ["a", "b"]' ║ ::jsonb ?& array['a', 'b'] ║ ["a", "b"]' ║ | |
║ || ║ jsonb ║ Menggabungkan 2 buah json kedalam 1 json ║ ["a", "b"]' ║ ::jsonb || '["c", "d"]'::jsonb ║ ["a", "b", "c", "d"]' ║ | |
║ - ║ text ║ Menghapus satu elemen json berdasarkan key x ║ {"a": "b"}' ║ ::jsonb - 'a' ║ {} ║ | |
║ - ║ integer ║ Menghapus satu elemen array berdasar index n ║ ["a", "b"]' ║ ::jsonb - 1 ║ ["a"] ║ | |
║ #- ║ text[] ║ Menghapus elemen json dengan path spesifik ║ ["a", {"b":1}]' ║ ::jsonb #- '{1,b}' ║ ["a", {}]' ║ | |
╚══════════╩═══════════════════╩══════════════════════════════════════════════════════════════════════════╩════════════════════════╩════════════════════════════════════╩════════════════════════╝ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment