How to convert empty string to 0 in postgres?

Question

PostgreSQL

The request has a piece cast(X as float)
Sometimes X can be an empty string, then it crashes with an error. What to use to convert '' to 0?

Answer 1

The construct COALESCE(NULLIF(X, ''), 0)will return 0 if X is NULL or an empty string.