By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
Single Byte | UTF-8 bytes |
---|---|
TAB TAB | 👾 |
SELECT 1
Code Point | UTF-16 Surrogate Pair | UTF-16 Surrogate Pair via UTF-32 | UTF-32 |
---|---|---|---|
༂ | 👾 | 👾 | 👾 |
SELECT 1
Highest UTF-32 Code Point |
---|
|
SELECT 1
ERROR: invalid Unicode escape value at or near "E'\U00110000" LINE 1: SELECT E'\U00110000' AS "1 Value Higher Than Highest UTF-32 ... ^
Code Point | UTF-16 Surrogate Pair | UTF-16 Surrogate Pair via UTF-32 | UTF-32 |
---|---|---|---|
༂ | 👾 | 👾 | 👾 |
SELECT 1