How to replace cells in a PostgreSQL column of type "infinity" with NaN?

Question

PostgreSQL

The table has column type Double precision, I can't change it to Numeric because of "infinity" cells
ERROR: cannot convert infinity to numeric
How can I change "infinity" to NaN to convert column type in table?
I will be grateful for help

Answer 1

UPDATE myTable SET myCol='NaN' WHERE myCol='Infinity'