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