X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 92CF352A87 for ; Fri, 8 Jul 2005 06:55:07 -0300 (ADT) 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 76755-09 for ; Fri, 8 Jul 2005 09:54:57 +0000 (GMT) Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by svr1.postgresql.org (Postfix) with ESMTP id 91701529C0 for ; Fri, 8 Jul 2005 06:54:56 -0300 (ADT) Received: from bell.credativ.de (p50890231.dip0.t-ipconnect.de [80.137.2.49]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 35750D7656; Fri, 8 Jul 2005 11:57:42 +0200 (CEST) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: where with NULL values are not selected Date: Fri, 8 Jul 2005 11:54:46 +0200 User-Agent: KMail/1.8.1 Cc: =?iso-8859-1?q?D=FCster_Horst?= References: <5B025B1F39D6D4119F5700508BEEEC6603DE3D8C@srsofaioi4546.ktso.ch> In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC6603DE3D8C@srsofaioi4546.ktso.ch> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200507081154.46530.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/60 X-Sequence-Number: 18116 Am Freitag, 8. Juli 2005 12:08 schrieb Düster Horst: > table1.column and table2.column may have NULL values. The problem is that > these columns where not selected. Does there exists any solution to > select/join the NULL value colums also. Read up on outer joins. In your case, try this: select table1.column from table1 full outer join table2 on (table1.column=table2.column); -- Peter Eisentraut http://developer.postgresql.org/~petere/