On Thu, Oct 1, 2009 at 12:19 AM, Shruthi A <shruthi.i...@gmail.com> wrote: > Hello, > > I have a query where I full-outer-join 2 tables, and all the columns other > than the join column are numerical columns. For my further calculations i > need to pad the unmatched tuples with 0 (zero) instead of NULL so that I can > perform meaningful mathematical calculations on them. Is this currently > possible?
something like select a.x, coalesce(b.y,0) from a left join b yada... work? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql