Re: Antw: LEFT JOIN - Mailing list pgsql-sql

From Tom Lane
Subject Re: Antw: LEFT JOIN
Date
Msg-id 28208.962739832@sss.pgh.pa.us
Whole thread Raw
In response to Re: Antw: LEFT JOIN  (Antti Linno <alligator@all.ee>)
List pgsql-sql
Antti Linno <alligator@all.ee> writes:
>> I think, the following select will solve your problem
>> 
>> select  first.id
>> from first
>> except
>> second.id_first 
>> from second;
>> 
> Nay, I got parse error.

Should be ... EXCEPT SELECT second.id_first ...

Anyway, we should have full ANSI join support in 7.2, or 7.1 if
we get lucky.
        regards, tom lane


pgsql-sql by date:

Previous
From: Rybarczyk Mikolaj
Date:
Subject: ODP: Antw: LEFT JOIN
Next
From: "Jean-Marc Libs"
Date:
Subject: Problem with joins