except command - Mailing list pgsql-admin

From olivier boissard
Subject except command
Date
Msg-id 46C099F6.8050002@cerene.fr
Whole thread Raw
Responses Re: except command  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Hello

I tried to use the except command in postgresql 8.1
I don't understand as it works
When I read doc , I understand that it was like a difference betwwen two
queries
However , It looks as if the 2nd part was ignored
I tried to test by dblink a query unising except on the same database
and all the records where returned
Do anybody know how it works ?

exemple:
select
    t1.columns   .....
from
    table_1  t1
EXCEPT
select
    t2.same_columns   .....
from
    table_2 t2

Olivier




pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Audit Trail
Next
From: "Kevin Grittner"
Date:
Subject: Re: except command