Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5MHSKa94503 for ; Fri, 22 Jun 2001 13:28:20 -0400 (EDT) (envelope-from reedstrm@rice.edu) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id ABF8968A0E for ; Fri, 22 Jun 2001 12:28:19 -0500 (CDT) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.22 #1 (Debian)) id 15DUiw-0003lT-00 for ; Fri, 22 Jun 2001 12:28:02 -0500 Date: Fri, 22 Jun 2001 12:28:02 -0500 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org Subject: Re: What is a "tuple" Message-ID: <20010622122802.C14381@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/385 X-Sequence-Number: 3681 On Fri, Jun 22, 2001 at 06:31:03PM +0200, Kristoff Bonne wrote: > Greetings, (and also Alex) > > On Fri, 22 Jun 2001, Josh Berkus wrote: > > > Excuse my lack my 'database'-jargon, but what is a 'tuple'? > > > Also known as a "Record", or a "Row". The word "tuple" is used because > > it can refer to a row returned as part of a result set as well as a > > record in a table. Strictly speaking, a row returned from most queries > > is not a record, as that row does not exist in permanent storage > > anywhere .... it is created by the query. Hence, "tuple". It's probably a back formation from the suffix 'tuple' as in the sequence: single, double, triple, quadruple, quintuple, sextuple, septuple, ... So, mathematicians generalized this (as is their wont) to [algebraic expression]-tuple, such as: n-tuple, (n^2)-tuple Which found their way to The Relational Algebra, simplified to just 'tuple' and hence, to SQL. Ross (way to much detail!) Reedstrom