Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

From: Bob Badour <bbadour_at_golden.net>
Date: Mon, 17 Mar 2003 00:07:46 -0500
Message-ID: <wddda.32$HD3.4875363_at_mantis.golden.net>


"Lauri Pietarinen" <lauri.pietarinen_at_atbusiness.com> wrote in message news:e9d83568.0303161526.100ec3fc_at_posting.google.com...
> 71062.1056_at_compuserve.com (--CELKO--) wrote in message
news:<c0d87ec0.0303141646.31440921_at_posting.google.com>...
>
> So the only valid alternative is to be very conservative and
> cautions from the start, hence the "principle of cautious design"
> is very valid indeed.
>
> > So far, SQL has removed ordinal position
> > numbers for columns as one concrete example.
>
> Does that mean that
>
> SELECT P#, PNAME
> FROM P
> ORDER BY 2
>
> is now depricated?
>
> If so, when do you think that will be reflected in
> products?

You might ask Joe whether deprecating column ordinals now allows:

SELECT P#, PNAME
 FROM P
 WHERE P# < 50
UNION
SELECT PNAME, P#
 FROM P
 WHERE P# > 50 Or must the ordinal of P# still match? Received on Mon Mar 17 2003 - 06:07:46 CET

Original text of this message