Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB15LEm27734 for ; Sat, 1 Dec 2001 00:21:14 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fB15LGi13695; Sat, 1 Dec 2001 00:21:17 -0500 (EST) To: "Peter T. Brown" cc: "'Jeff Eckermann'" , pgsql-sql@postgresql.org Subject: Re: contracting tables In-reply-to: <010a01c179c6$e5874ea0$7d00000a@PETER> References: <010a01c179c6$e5874ea0$7d00000a@PETER> Comments: In-reply-to "Peter T. Brown" message dated "Fri, 30 Nov 2001 09:46:09 -0800" Date: Sat, 01 Dec 2001 00:21:16 -0500 Message-ID: <13692.1007184076@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200112/1 X-Sequence-Number: 5824 "Peter T. Brown" writes: > I cannot seem to find the EXISTS keyword anywhere in the postgresql > documentation. Er ... um ... well ... there isn't any doco about EXISTS ... nor related constructs such as IN. I've attempted to rectify this in the 7.2-to-be docs, see http://candle.pha.pa.us/main/writings/pgsql/sgml/functions-subquery.html It's a tad on the dry-and-technical side, for sure. You might prefer to consult an introductory SQL book or three. regards, tom lane