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?

sql postgresql null max
Edit
Report