X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A77C28B9D0B for ; Mon, 31 Jan 2005 21:14:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57793-08 for ; Mon, 31 Jan 2005 21:14:33 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 8F1158B9C44 for ; Mon, 31 Jan 2005 21:14:33 +0000 (GMT) Received: (qmail 8685 invoked from network); 31 Jan 2005 21:14:33 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.22?) (64.3.242.80) by 0 with SMTP; 31 Jan 2005 21:14:33 -0000 In-Reply-To: <6c21003b0501311306c5f944@mail.gmail.com> References: <6c21003b0501301141234c256b@mail.gmail.com> <9719e3dd9d6201fc40efcf3a15b82442@sitening.com> <6c21003b0501311306c5f944@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-sql@postgresql.org From: Thomas F.O'Connell Subject: Re: plpgsql functions and NULLs Date: Mon, 31 Jan 2005 15:14:19 -0600 To: Don Drake X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/316 X-Sequence-Number: 20104 As far as I know, you didn't post your actual table definitions (or full queries) earlier, so I'm not exactly sure what you mean. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Jan 31, 2005, at 3:06 PM, Don Drake wrote: > My outer query to get the candidates has an outer join, that works > just fine and I get the null OMCR_ID's. > > It's when I have to query the dimension table (no joins) to see if a > row exists with a (sometimes) null OMCR_ID I'm forced to write 2 > queries, when I think I should only have to write one. > > Thanks. > > -Don