unicode.out 882 B

12345678910111213141516171819202122232425262728293031
  1. SELECT "normalize"('abc', 'def'); -- run-time error
  2. ERROR: invalid normalization form: def
  3. SELECT U&'\00E4\24D1c' IS NFC NORMALIZED AS test_nfc;
  4. test_nfc
  5. ----------
  6. t
  7. (1 row)
  8. SELECT num, val,
  9. val IS NFC NORMALIZED AS NFC,
  10. val IS NFD NORMALIZED AS NFD,
  11. val IS NFKC NORMALIZED AS NFKC,
  12. val IS NFKD NORMALIZED AS NFKD
  13. FROM
  14. (VALUES (1, U&'\00E4bc'),
  15. (2, U&'\0061\0308bc'),
  16. (3, U&'\00E4\24D1c'),
  17. (4, U&'\0061\0308\24D1c'),
  18. (5, '')) vals (num, val)
  19. ORDER BY num;
  20. num | val | nfc | nfd | nfkc | nfkd
  21. -----+-----+-----+-----+------+------
  22. 1 | äbc | t | f | t | f
  23. 2 | äbc | f | t | f | t
  24. 3 | äⓑc | t | f | f | f
  25. 4 | äⓑc | f | t | f | f
  26. 5 | | t | t | t | t
  27. (5 rows)
  28. SELECT is_normalized('abc', 'def'); -- run-time error
  29. ERROR: invalid normalization form: def