Re: What is a tuple?

Perhaps I've been incorrect but I've normally used 'row' when referring to
the tuple that actually exists on disk and returned by a straight SELECT

SELECT attr,attr,attr FROM ...

I've used tuple when I want to refer to the virtual, only in memory row
that is created through things like:

SELECT a.attr,b.attr FROM ... a, ... b

My point being that when I'm talking about something more abstract to use
the more abstract form. It's just sort of a way for me to keep things
straight in conversation.

Joshua b. Jore ; http://www.greentechnologist.org

On Fri, 28 Jun 2002, Chris Humphries wrote:

> well a row is more a visualation word, when you do a select, you
> get "rows" back... they look like rows...
>
> a tuple is actually what it is. not meant to impress, but just what
> it is. a tuple is defined as "a data object containing two or more
> components".
>
> hope this clears up some confusion.
>
> -chris
>
>
> =On Thu, Jun 27, 2002 at 09:17:22AM -0400,
> =recieved 1.4K bytes from David Siebert containing this:
> > Tuple = row... Why not just use row? I know what a tuple is but it seems
> > like a word to impress more than inform.
> >
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Martijn van
> > Oosterhout
> > Sent: Tuesday, June 25, 2002 10:54 PM
> > To: Elaine Lindelef
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] What is a tuple?
> >
> >
> > On Tue, Jun 25, 2002 at 02:40:03PM -0700, Elaine Lindelef wrote:
> > > My apologies for the stupid question, but before I started using
> > > postgres I never came across the word "tuple" quite in this context
> > > before. I know a "tuple" as "a data object containing two or more
> > > components" ... but I'm not sure of its precise meaning in the
> > > postgres universe. Is a tuple a row, a field value, a field value
> > > paired with its datatype, what? If someone asks me the size of my
> > > largest tuple, how do I calculate it? It seems to be related deeply
> > > to the structure of postgres somehow.
> >
> > A tuple is a row. Isn't this in the glossary somewhere?
> > --
> > Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > > There are 10 kinds of people in the world, those that can do binary
> > > arithmetic and those that can't.
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>