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?.
1 rows affected
1 rows affected
1 rows affected
id | regexp_split_to_table |
---|---|
1 | What a great day |
2 | This is a product. It is useful |
3 | ['a' |
3 | ' ' |
3 | ' ' |
3 | 'b'] |
id | regexp_replace |
---|---|
1 | What a great day |
2 | This is a product It is useful |
3 | a |
3 | |
3 | |
3 | b |
id | string_to_array |
---|---|
1 | {What,a,great,day} |
2 | {This,is,a,product,It,is,useful} |
3 | {a} |
3 | {"","",""} |
3 | {"","",""} |
3 | {"",b} |
id | Word_count | Distinct_count | description |
---|---|---|---|
1 | 4 | 4 | What a great day |
2 | 7 | 6 | This is a product. It is useful |
3 | 2 | 2 | ['a', ' ', ' ', 'b'] |