If I understand you exactly, you may use except:
select distinct * from prodlang
except
select distinct * from prodlang2
gives you the records which exist in prodlang and do not exist in
prodlang2. So you get all the records in prodlang which are newly
inserted or updated.
regards
erol
Zot O'C
Antti Linno wrote:
>
> > 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.
'select' is missing after 'except'.
select first.id
from first
except
select second.id_firs
Hi,
You may find examples in the section 'Joining Tables' of Bruce Momjian's
marvelous work.
http://www.postgresql.org/docs/aw_pgsql_book/node63.html
I hope this helps.
Regards
Erol
CB wrote:
> Hi,
>
> Can someone tell me which (if any) joins are supported with 7? It
> appears the answer is 'n
