By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| id | test_json |
|---|---|
| 1 | {"test_name": "Full", "parameter1": "4.219", "parameter2": 4.4137} |
| 2 | {"test_name": "Full", "parameter1": "}", "parameter2": 4.159} |
| 3 | {"test_name": "Full", "parameter1": "u", "parameter2": 4.159} |
| 4 | {"test_name": "Full", "parameter1": "3.758", "parameter2": 4.159} |
| regexp_replace |
|---|
| {"test_name": "Full", "parameter1": "4.219", "parameter2": 4.4137} |
| {"test_name": "Full", parameter2": 4.159} |
| {"test_name": "Full", parameter2": 4.159} |
| {"test_name": "Full", "parameter1": "3.758", "parameter2": 4.159} |