Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 696D99F95D4 for ; Mon, 13 Aug 2007 14:55:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 32208-09 for ; Mon, 13 Aug 2007 14:55:28 -0300 (ADT) X-Greylist: delayed 00:05:10.241015 by SQLgrey-1.7.5 Received: from mx.imatech.net (mx.imatech.net [81.255.215.253]) by postgresql.org (Postfix) with ESMTP id 3EBA29F997F for ; Mon, 13 Aug 2007 14:55:29 -0300 (ADT) X-AuthUser: olivier.boissard@cerene.fr Received: from [200.200.200.34] ([195.6.193.141]:60952) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Mon, 13 Aug 2007 19:50:13 +0200 Message-ID: <46C099F6.8050002@cerene.fr> Date: Mon, 13 Aug 2007 19:50:46 +0200 From: olivier boissard User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: except command Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.001, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200708/132 X-Sequence-Number: 26463 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