Can i customize null-padding for outer joins?

From: Shruthi A <shruthi(dot)iisc(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Can i customize null-padding for outer joins?
Date: 2009-10-01 06:19:53
Message-ID: 6caee9520909302319w638c4feara4ead3402e5e00c0@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Thanks a ton!
Shruthi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2009-10-01 06:22:28 Re: Can i customize null-padding for outer joins?
Previous Message Peter Eisentraut 2009-10-01 06:05:53 Re: Pg_Restore with --clean option