Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with left outer join - Mailing list pgsql-novice

From Tom Lane
Subject Re: problems with left outer join
Date
Msg-id 12359.1160055307@sss.pgh.pa.us
Whole thread Raw
In response to problems with left outer join  ("Andreas Andreakis" <andreas.andreakis@googlemail.com>)
List pgsql-novice
Tree view 
"Andreas Andreakis" <andreas.andreakis@googlemail.com> writes:
> So I tried:

> select *
> from A t1 left outer join B t2 on t1.id = t2.id
> where t2.id = null

You need "IS NULL", not "= NULL".  See
http://www.postgresql.org/docs/8.1/static/functions-comparison.html

            regards, tom lane

pgsql-novice by date:

Previous
From: Andy Chambers
Date:
Subject: Re: problems with left outer join
Next
From: Ray Stell
Date:
Subject: Re: pg_ctl -D?