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 myarea (
area_name text
);
INSERT INTO myarea VALUES
('MyAREA'), ('myarea'), ('yourarea')
CREATE TABLE
INSERT 0 3
SELECT * FROM myarea
WHERE area_name = 'myarea';
| area_name |
|---|
| myarea |
SELECT 1
SELECT * FROM myarea
WHERE area_name ILIKE 'myarea';
| area_name |
|---|
| MyAREA |
| myarea |
SELECT 2
SELECT * FROM myarea
WHERE area_name ILIKE '%area'; -- pattern matching
| area_name |
|---|
| MyAREA |
| myarea |
| yourarea |
SELECT 3
SELECT * FROM myarea
WHERE lower(area_name) = lower('MyAREA');
| area_name |
|---|
| MyAREA |
| myarea |
SELECT 2