Re: where with NULL values are not selected - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: where with NULL values are not selected
Date
Msg-id 200507081154.46530.peter_e@gmx.net
Whole thread Raw
In response to where with NULL values are not selected  (Düster Horst <Horst.Duester@bd.so.ch>)
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: Düster Horst
Date:
Subject: where with NULL values are not selected
Next
From: Dawid Kuroczko
Date:
Subject: Re: where with NULL values are not selected