Postgres 16

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

create table test ("name" varchar(30))

CREATE TABLE


insert into test values
('XYZ Company Corporation'),
('XYZ Association Inc'),
('XYZ Income Corp Inc')

INSERT 0 3


SELECT CASE WHEN "name" LIKE '% Inc' THEN REGEXP_REPLACE("name", ' Inc$', '') ELSE "name" END AS "name1",
       REGEXP_REPLACE("name", ' Inc$', '') AS "name2",
       CASE WHEN "name" LIKE '% Inc' THEN LEFT("name", LENGTH("name")-4) ELSE "name" END AS "name3"
FROM test


name1
name2
name3


XYZ Company Corporation
XYZ Company Corporation
XYZ Company Corporation

XYZ Association
XYZ Association
XYZ Association

XYZ Income Corp
XYZ Income Corp
XYZ Income Corp



SELECT 3

name1	name2	name3
XYZ Company Corporation	XYZ Company Corporation	XYZ Company Corporation
XYZ Association	XYZ Association	XYZ Association
XYZ Income Corp	XYZ Income Corp	XYZ Income Corp