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?.
string_agg |
---|
01111011101101010111110111110111 |
SELECT 1
value |
---|
\xdeadbeef |
SELECT 1
value |
---|
\xdeadbeef |
SELECT 1
value | count_bytes |
---|---|
\xdeadbeef | 4 |
SELECT 1
value | gs |
---|---|
\xdeadbeef | 0 |
\xdeadbeef | 1 |
\xdeadbeef | 2 |
\xdeadbeef | 3 |
SELECT 4
get_byte |
---|
222 |
173 |
190 |
239 |
SELECT 4
get_byte |
---|
11011110 |
10101101 |
10111110 |
11101111 |
SELECT 4
string_agg |
---|
11011110101011011011111011101111 |
SELECT 1
CREATE FUNCTION
to_bit |
---|
11011110101011011011111011101111 |
SELECT 1