Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BD7CD633486
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  1 Oct 2009 03:20:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 25397-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  1 Oct 2009 06:19:55 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f175.google.com (mail-iw0-f175.google.com
	[209.85.223.175])
	by mail.postgresql.org (Postfix) with ESMTP id DB32163283E
	for <pgsql-sql@postgresql.org>; Thu,  1 Oct 2009 03:19:54 -0300 (ADT)
Received: by iwn5 with SMTP id 5so3856548iwn.15
	for <pgsql-sql@postgresql.org>; Wed, 30 Sep 2009 23:19:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=ZmbX5pzCDKGihI0hpj7CI0W2W59pULkJ4Z55+l8/d08=;
	b=PQM5c2cVVPBFRM17QvvuQeewly65NUabtwcxsRy0nreJsnrIZBimm6kTtrULc6mtM8
	9aHbb+udjIleRblWRLqWcWjcbIBQYTJLh9phcju+48+kGANr7Ed932z8LMePmZ4VzTm5
	3amKH7kpdx3/ZTCS1AjHgLBDtL5WlsyV6DhGo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=s+oZBkAG2sFJa/Gx9cWlYwWqB8pOYRbDGUVQCDWMFR/2lIf0Av2Kj7E96+j7L+/Vj1
	wK6Ap6kqXq8iZDRK0VCRjGnq2/ssHPpCFkpqYFri8Q9+Ar9K3LlWvXvRhSl+QUfc1nL+
	toexIND5E41qY1Mfxi7iZHMGJiv2e77eT+ziI=
MIME-Version: 1.0
Received: by 10.231.22.38 with SMTP id l38mr1541295ibb.34.1254377993634; Wed,
	30 Sep 2009 23:19:53 -0700 (PDT)
Date: Thu, 1 Oct 2009 11:49:53 +0530
Message-ID: <6caee9520909302319w638c4feara4ead3402e5e00c0@mail.gmail.com>
Subject: Can i customize null-padding for outer joins?
From: Shruthi A <shruthi.iisc@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0015176f0cf4b984660474d9a29c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200910/3
X-Sequence-Number: 33202

--0015176f0cf4b984660474d9a29c
Content-Type: text/plain; charset=ISO-8859-1

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

--0015176f0cf4b984660474d9a29c
Content-Type: text/html; charset=ISO-8859-1

<span class="postbody">Hello,
<br> <br>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? <br><br>Thanks a ton!<br>Shruthi<br></span>

--0015176f0cf4b984660474d9a29c--