Question : I have a Postgresql column that is a varchar that is saving a string that looks like ‘2 […]

Question : Why does casting this result of REGEXP_SUBSTR() to a DECIMAL fail? SELECT REGEXP_SUBSTR(‘Cost (-$14.18)’, ‘(?<=Cost [(]-[$])[0-9.]+’) AS _extracted, […]