Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA07453 for ; Sun, 19 Dec 1999 22:11:20 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id WAA17761; Sun, 19 Dec 1999 22:10:48 -0500 (EST) To: Barry Baldwin cc: PGSQL-SQL Subject: Re: [SQL] MINUS emulation? In-reply-to: <319A9588FB5ED2119FAC00A0C912E3292785C0@INDYMEEXCH> References: <319A9588FB5ED2119FAC00A0C912E3292785C0@INDYMEEXCH> Comments: In-reply-to Barry Baldwin message dated "Sun, 19 Dec 1999 17:47:06 -0800" Date: Sun, 19 Dec 1999 22:10:48 -0500 Message-ID: <17758.945659448@sss.pgh.pa.us> From: Tom Lane Barry Baldwin writes: > Select field_id, data > from table_1 > minus > Select field_id, data > from table_2; The SQL standard spelling for this is "EXCEPT", not "MINUS". regards, tom lane