add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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']