By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.23 |
select '123' / 1
union all
select '12.3' / 1
union all
select '.123' / 1
union all
select '12A3' / 1
union all
select 'A123' / 1
union all
select '.1A1.' / 1;
| '123' / 1 |
|---|
| 123 |
| 12.3 |
| 0.123 |
| 12 |
| 0 |
| 0.1 |