Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA38588 for ; Fri, 26 Nov 1999 12:48:35 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id MAA15336 for pgsql-general@postgreSQL.org; Fri, 26 Nov 1999 12:39:25 -0500 (EST) Received: from renoir.op.net (root@renoir.op.net [209.152.193.4]) by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id LAA13593 for ; Fri, 26 Nov 1999 11:01:11 -0500 (EST) Received: from depredador.sefes.es ([194.179.85.3]) by renoir.op.net (o1/$Revision: 1.18 $) with ESMTP id KAA11099 for ; Fri, 26 Nov 1999 10:57:39 -0500 (EST) Received: from perti.com ([195.77.50.22]) by depredador.sefes.es (Netscape Mail Server v2.0) with SMTP id AAA12609 for ; Fri, 26 Nov 1999 16:54:48 +0200 Received: (qmail 2346 invoked from network); 26 Nov 1999 17:49:54 -0000 Received: from e25.localnet.net (192.168.1.25) by sl1.localnet.net with SMTP; 26 Nov 1999 17:49:54 -0000 Reply-To: From: "Horaci Cuevas" To: Subject: PostgreSQL Date: Fri, 26 Nov 1999 16:49:55 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from base64 to 8bit by candle.pha.pa.us id LAA13593 Sender: pgman@candle.pha.pa.us Hi! I'm using PostgreSQL for a search-web based database, and i saw a missing function mostly found in DB2 and others, where, you can get results from a query having a WHERE condition to exist or not in another SQL sentence . In DB2 is: SELECT field1, field2 FROM tab1 WHERE field1 IN ( select field3 from tab2 ) or SELECT field1, field2 FROM tab1 where field1 NOT IN ( select field3 from tab2 ) PostgreSQL already has that, but only allows to return 1 result, ex: SELECT field1, field2 FROM tab1 where field1 = ( select field 3 from tab2 where id=1 ) Would be great if that where added to the TODO as a future Feature. Thanks in Advance. Horaci Cuevas.