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 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
SELECT 1
CREATE TABLE test
(
x TEXT
);
CREATE TABLE
INSERT INTO test VALUES
('afadfdsfzgertet');
INSERT 0 1
SELECT * FROM test;
| x |
|---|
| afadfdsfzgertet |
SELECT 1
SELECT
REGEXP_REPLACE(x, '[a-z]+', '[A-Z]', 'g') -- have tried \l \L, \u \U...
FROM
test;
| regexp_replace |
|---|
| [A-Z] |
SELECT 1
SELECT regexp_replace('foobarbaz', 'b..', 'X');
| regexp_replace |
|---|
| fooXbaz |
SELECT 1