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?.
version |
---|
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
try_cast |
---|
3 |
null |
14 rows affected
a | b | c |
---|---|---|
|3|3| some stuff here | 3 | 3 |
|SE + 18.5D some other stuff | null | null |
|54|45| yet more stuff | 54 | 45 |
|32|23| yet more |78|78| stuff | 32 | 23 |
|This is more text |11|111|22222||| and stuff ||||||| | null | null |
|1 1|1 1 1|22222| | null | null |
|7125341246362562654562465|ahgsdfhgasfghasf | null | null |
|-567|-765|A test of negatives... | -567 | -765 |
|--567|-765|A test of bad negatives... | null | null |
|000|00|A test of zeroes... | null | null |
|0|34| first zero | 0 | null |
|45|0| second zero | 45 | null |
|0|0| both zeroes | 0 | null |
|aadfsd|34|Fails if first fails - deliberate - Unix philosophy! | null | null |
ERROR: syntax error at or near "["
LINE 1: ([-+]?[1-9]|[-+]?[1-9][0-9]|[-+]?[1-9][0-9][0-9])
^