Re: How to identify a column in order by clause

-CELKO- wrote:
> 1) No it does not in a relational model, which is why positional were
> deprecated in SQL-92

Needless to say any commercial product that contains deprecated syntax will hold on to it for a decade so as not to break existing apps.

> 2) Hey, if you throwing out the basic SQL model, why not allow computed
> references, like pointer math in C, et al?

I don't know. The basic SQL model was thrown out by many of the vendors long ago. I know that doesn't make you happy but it is a fact.

> 3) The phrase "Standard Oracle" is an oxymoron. That product is a
> screwed up mess from a Standards virewpoint, a RDBMS viewpoint and an
> Relational viewpoint. Have you seen Rich Finkelstein's slide show
> about all of the marketing lies, frauds, etc. done by this company?

If you want ANSI standard SQL there is always Teradata ;-) Or have they deviated recently too. You seem to do most of your work in SQL Server and you certainly can't lay any claim to ANSI purity there. And to point to one vendor and say "marketing lies, frauds, etc." without pointing to all of them is a bit disingenuous methinks. Anyone without enough IQ horsepower to read through the advertising claims for Listerine and anti-perspirants is certainly not capable of coding an application or writing an outer join.

> 4) Agreed. Which is one of the many reasons that (1) is useless in a
> language that claims to be orthogonal.

Does a polar bear, under an appropriate coordinate transformation, become a rectangular bear?

I don't use a product because it adheres or doesn't adhere to specs created by a standards committee and as near as I can tell neither does anyone else. They buy what they think will do the job and I choose that which I think will pay the mortgage. Software as a religion complete with holy scripture is not likely to ever exist.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---