Can i customize null-padding for outer joins? - Mailing list pgsql-sql

<span class="postbody">Hello, <br /><br />I have a query where I full-outer-join 2 tables, and all the columns other
thanthe join column are numerical columns. For my further calculations i need to pad the unmatched tuples with 0 (zero)
insteadof NULL so that I can perform meaningful mathematical calculations on them. Is this currently possible? <br
/><br/>Thanks a ton!<br />Shruthi<br /></span>