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?.
select version();
| version |
|---|
| PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit |
SELECT 1
CREATE TABLE string_entries
(str character varying)
;
INSERT INTO string_entries
(str)
VALUES
('aaa,bbbb,foo,zzz,bar'),
('bar,ccc,ddddd,foo,iiiii'),
('aaa,eeeee,foo,rrrrrr,hhhhhh'),
('ooooo,ii,sssss,bar,xxxx')
;
select str from string_entries where str ~ '^(?=.*(?:,|^)foo(?:,|$))(?=.*(?:,|^)bar(?:,|$))';
CREATE TABLE
INSERT 0 4
| str |
|---|
| aaa,bbbb,foo,zzz,bar |
| bar,ccc,ddddd,foo,iiiii |
SELECT 2