except command

Поиск
Список
Период
Сортировка
От olivier boissard
Тема except command
Дата
Msg-id 46C099F6.8050002@cerene.fr
обсуждение исходный текст
Ответы Re: except command  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Audit Trail
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: except command