Postgres 9.5

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?.

----https://stackoverflow.com/questions/52993675/simple-negative-lookahead-in-postgres-9-5-not-working

CREATE TABLE table1
    (s character varying)
;

INSERT INTO table1
    (s)
VALUES
    ('FROM THE STORE TO THE HOUSE AND'),
    ('FROM THE HOUSE TO THE STORE AND')
;

2 rows affected

select * from table1 where s ~ '(STORE)(?!HOUSE)';

s

FROM THE STORE TO THE HOUSE AND

FROM THE HOUSE TO THE STORE AND

--Toto answer

select * from table1 where s ~ '(STORE)((?!HOUSE).)*$';

s

FROM THE HOUSE TO THE STORE AND