Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5PBXLa67905 for ; Mon, 25 Jun 2001 07:33:21 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 25 Jun 2001 11:33:17 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f5PBWx207870; Mon, 25 Jun 2001 07:32:59 -0400 From: Jan Wieck Message-Id: <200106251132.f5PBWx207870@jupiter.us.greatbridge.com> Subject: Re: What is a "tuple" In-Reply-To: <20010622122802.C14381@rice.edu> from "Ross J. Reedstrom" at "Jun 22, 2001 12:28:02 pm" To: "Ross J. Reedstrom" Date: Mon, 25 Jun 2001 07:32:58 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/398 X-Sequence-Number: 3695 Ross J. Reedstrom wrote: > 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 At least it's for sure detailed enough :-) Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com