add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit
SELECT 1
ERROR:  syntax error at or near "to"
LINE 1: CREATE TABLE to-do_list
                     ^
CREATE TABLE
ERROR:  syntax error at or near "to"
LINE 1: INSERT INTO to-do_list VALUES (1, 'fasdfa'), (2, 'afdsf');
                    ^
INSERT 0 2
ERROR:  syntax error at or near "to"
LINE 1: SELECT * FROM to-do_list;
                      ^
f1 f2
1 fasdfa
2 afdsf
SELECT 2