Postgresql turn null into zero

Question

Possible Duplicate:
SELECT max(x) is returning null; how can I make it return 0?

When I execute

select max(column) from mytable;

and my table has no rows, it returns null. How can I amend this select statement so it will return zero?

Solution 1

select coalesce(max(column), 0) from mytable; 

Solution 2

Try:

SELECT coalesce(max(column), 0) myalias FROM mytable;

Solution 3

Do either of these work?

• select coalesce(max(foo),0) from bar
  

• coalesce((select max(foo) from bar),0)
  

Comments

[Ajay Kumar]

Worked like a charm!!!!