RE: Random ordering

Ummm...not to mention the fact that SQL (the SQL standard, that is) 
has nothing spelled "random" with or without parens.  I'm certain 
that a number of implementations provide such a facility or function, 
but "SQL" does not.

Finally, the relational model, of which SQL is an imprecise 
implementation, says that, absent an explicit instruction to order 
results, the results are in an undefined order.  Therefore, it is 
arguable that such a facility isn't needed in any case.

As Mike said, you really need to help us understand what value this 
facility might add, as well as what it actually means.

Hope this helps,
    Jim

At 5/23/2007 06:05 AM, Michael Kay wrote:

> > Hi! Will next XQuery spec allow something like "order by
> > random()", similar to SQL?
> >
>
>I don't think is currently on the requirements list. If you want it added,
>you'll need to explain what you expect it to do and why it's a good idea
>(don't imagine that people can guess the semantics from the syntax).
>
>Michael Kay
>http://www.saxonica.com/

========================================================================
Jim Melton --- Editor of ISO/IEC 9075-* (SQL)     Phone: +1.801.942.0144
   Co-Chair, W3C XML Query WG; F&O (etc.) editor    Fax : +1.801.942.3345
Oracle Corporation        Oracle Email: jim dot melton at oracle dot com
1930 Viscounti Drive      Standards email: jim dot melton at acm dot org
Sandy, UT 84093-1063 USA          Personal email: jim at melton dot name
========================================================================
=  Facts are facts.   But any opinions expressed are the opinions      =
=  only of myself and may or may not reflect the opinions of anybody   =
=  else with whom I may or may not have discussed the issues at hand.  =
======================================================================== 

Received on Monday, 28 May 2007 19:24:26 UTC