Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder4.news.weretis.net!feeds.phibee-telecom.net!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: Lawrence D'Oliveiro Newsgroups: comp.lang.java.programmer Subject: Re: SQL Puzzle - too many dimensions Followup-To: comp.lang.java.programmer Date: Fri, 13 May 2011 22:55:07 +1200 Organization: Geek Central Lines: 26 Message-ID: References: <3Boxp.9547$HF3.5013@newsfe03.iad> <92r02mF24dU1@mid.individual.net> NNTP-Posting-Host: 118-92-95-178.dsl.dyn.ihug.co.nz Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8Bit X-Trace: lust.ihug.co.nz 1305284107 18590 118.92.95.178 (13 May 2011 10:55:07 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Fri, 13 May 2011 10:55:07 +0000 (UTC) User-Agent: KNode/4.4.7 Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:4046 In message , Robert Klemme wrote: > On 10 Mai, 03:50, Lawrence D'Oliveiro central.gen.new_zealand> wrote: > >> In message <92r02mF24...@mid.individual.net>, Robert Klemme wrote: >> >> > That's called an "inline view". >> >> The only reason there’s a special term for it is because SQL doesn’t >> treat tables/views as first-class objects. > > There are no objects in SQL. SQL is neither procedural nor object > oriented. I didn’t say it was “object-oriented”. In Computer Science, we use the term “first-class object” to refer to what you can do with objects, not object- orientation . > It is a declarative language implementing relational > algebra. If it DID implement proper relational algebra as it is mathematically defined, we wouldn’t have this problem.