By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| nr | cast | to_char0 | to_char1 | to_char2 | to_char3 | to_char4 |
|---|---|---|---|---|---|---|
| 123 | 123.0000 | 123. | #.#### | #.#### | #.#### | #.#### |
| 1.2 | 1.2000 | 1.2 | 1.2000 | 1.2000 | 1.2 | 1.2000 |
| 0.00000 | 0.0000 | 0. | 0.0000 | 0.0000 | 0. | 0.0000 |
| -0.039 | -0.0390 | -0.039 | -0.0390 | -0.0390 | -0.039 | -0.0390 |
| 0.039 | 0.0390 | 0.039 | 0.0390 | 0.0390 | 0.039 | 0.0390 |
| 0.0390 | 0.0390 | 0.039 | 0.0390 | 0.0390 | 0.039 | 0.0390 |
| 0.039000 | 0.0390 | 0.039 | 0.0390 | 0.0390 | 0.039 | 0.0390 |
| 0.0391234 | 0.0391 | 0.0391 | 0.0391 | 0.0391 | 0.0391 | 0.0391 |
| 123456789.039123456789 | 123456789.0391 | 123456789.0391 | #.#### | #.#### | #.#### | #.#### |
| 123456789.039123456789123456789 | 123456789.0391 | 123456789.0391 | #.#### | #.#### | #.#### | #.#### |
SELECT 10