Received: from mailer.zkm.de (mailer.zkm.de [193.197.168.18]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA83515 for ; Mon, 3 May 1999 09:22:41 -0400 (EDT) (envelope-from fischer@zkm.de) Received: from zkm.de (joerg@www4.zkm.de [193.197.168.203]) by mailer.zkm.de (8.8.8/8.8.8) with ESMTP id PAA26733 for ; Mon, 3 May 1999 15:20:50 +0200 (MET DST) Sender: joerg@zkm.de Message-ID: <372DA3DC.8EEAF089@zkm.de> Date: Mon, 03 May 1999 15:25:48 +0200 From: Joerg Fischer Organization: ZKM Karlsruhe X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: de, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: No DIVIDE Operator Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi! Consider the following szenario: Two Tables: create table Person ( name text, prename text, street text, town text ); create table Officer ( name text, prename text, bureau text ); So, every Officer is a Person. Now, I would like to get all persons except for Officers. If there would be a divide operator, I could write select name, prename from Person divide select name, prename from Officer; without it, however, things get really complicated: select name, prename from Person where prename not in ( select prename from Officer where Officer.name = Person.name ); This is an easy example. However, I have to deal with about 10 tables in a corresponding way. Any better idea? Will there be a divide operator in PGSQL soon? Thanks! Regards Joerg Fischer