Received: from mailer.zkm.de (mailer.zkm.de [193.197.168.18]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA95780 for ; Mon, 3 May 1999 10:32:34 -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 QAA28034; Mon, 3 May 1999 16:30:33 +0200 (MET DST) Sender: joerg@zkm.de Message-ID: <372DB432.41A37050@zkm.de> Date: Mon, 03 May 1999 16:35:30 +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: Chris Bitmead CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] No DIVIDE Operator References: <372DA3DC.8EEAF089@zkm.de> <372DAFD5.FAA368B1@bigfoot.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chris Bitmead wrote: > > Isn't that what EXCEPT does? Maybe the operator is named differently between different database systems. Anyway, as far as I am concerned, PGSQL lacks it. Or (hopefully), am I wrong?? Regards Joerg Fischer > chris=> create table foo (text text); > CREATE > chris=> insert into foo values('aaa'); > INSERT 22153 1 > chris=> insert into foo values('bbb'); > INSERT 22154 1 > chris=> insert into foo values('ccc'); > INSERT 22155 1 > chris=> select * from foo EXCEPT select 'aaa'; > text > ---- > bbb > ccc > (2 rows) > > > 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