- From: Jim Melton <jim.melton@acm.org>
- Date: Mon, 28 May 2007 12:41:04 -0600
- To: "Michael Kay" <mhk@mhk.me.uk>
- Cc: "'Markus Jonsson'" <carnaby@passagen.se>, <public-qt-comments@w3.org>
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