Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id VAA04628 for ; Thu, 18 Mar 1999 21:21:09 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id VAA13530; Thu, 18 Mar 1999 21:21:03 -0500 (EST) From: Bruce Momjian Message-Id: <199903190221.VAA13530@candle.pha.pa.us> Subject: UNION docs To: lockhart@alumni.caltech.edu (Thomas G. Lockhart) Date: Thu, 18 Mar 1999 21:21:03 -0500 (EST) Cc: docs@postgresql.org (PostgreSQL-documentation) X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I't unnI don't understand this: The UNION operator specifies a table derived from a Cartesian product. The two tables that represent the direct operands of the UNION must have the same number of columns, and corresponding columns must be of compatible data types. Why do you call it a cartesian product. I thought a cartesian product was tableA x tableB, while UNION is really tableA + tableB, right? If I am right, can you change the docs? I will leave it as is. Thanks. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026