unicode.sql 393 B

12345678910111213141516
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. -- Check access to members with unicode keys
  4. $json = CAST(@@{
  5. "привет": 123
  6. }@@ as Json);
  7. SELECT
  8. JSON_EXISTS($json, @@strict $."привет"@@),
  9. JSON_VALUE($json, @@strict $."привет"@@);
  10. $nested_json = CAST(@@{
  11. "привет": [1, 2, 3]
  12. }@@ as Json);
  13. SELECT
  14. JSON_QUERY($nested_json, @@strict $."привет"@@);