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?.
11000 rows affected
1 rows affected
1131 rows affected
ctid city_id city other_names_lower
(87,93) 11001 %foobar %fooелезbar
(87,92) 11000 UPA BBTSQM UPA BBTSQM
(87,91) 10999 DGPPGIRCE HCCNE DGPPGIRCE HCCNE
86 rows affected
ctid city_id city other_names_lower
(86,124) 10908 TCDPX TYFPTT TCDPX TYFPTT
(86,123) 10907 TUWQXMRRF HMEUMHNX TUWQXMRRF HMEUMHNX
(86,122) 10906 BIDIBVS GNYNW BIDIBVS GNYNW