if null put 0 in postgres query code example

Example: postgresql if null then 0

select coalesce(avg(bar), 0) from foo;