Re: The job of a relational DBMS
Date: Tue, 8 Dec 2009 16:12:04 -0800 (PST)
On Nov 30, 8:52 pm, Ben Finney <bignose+hates-s..._at_benfinney.id.au> wrote:
> Gene Wirchenko <ge..._at_ocis.net> writes:
> > On Tue, 01 Dec 2009 13:45:44 +1100, Ben Finney
> > <bignose+hates-s..._at_benfinney.id.au> wrote:
> > >What I was trying to express was that relational operations — like
> > >the various relational operations that ‘SELECT’ implements — should
> > >only return data as relations (they might also return status
> > >responses). They should never return non-relation data.
> > A relation does not have order. This would not be a relation
> > select clicode,cliname from clients order by clicode
> > because of the order by clause.
> Hmm. I'm not sure it's right to say the result would not *be* a
> relation; but I certainly take the point about ‘ORDER BY’ requesting
> order be imposed on an orderless relation.
Should anyone care, I ran across this while meditating upon Chris Date
giving a seminar in Dallas next month:
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2009/dec/07/man-gets-18-months-in-prison-for-computer-fraud/Received on Tue Dec 08 2009 - 18:12:04 CST