How to convert "" to NULL in PostgreSQL

Question

I'm with a problem in PostgreSQL. I need to do something like this:

select * from single_occurrences
where 
age::int4 > 29

And I got this error:

ERROR:  invalid input syntax for integer: ""

The field age is a text field. How can I convert all the "" values to NULL values?

Best Regards,

Answer 1

SELECT *
  FROM single_occurrences
 WHERE CASE WHEN age="" THEN NULL ELSE age::int4 END > 29

Answer 2

UPDATE single_occurrences SET age=NULL WHERE age="";