> >>Please note that the SQL standard does not prohibid stable sorting
> >>outcome.
> >
> >It does prohibit it. It states the output is not sorted unless
> >you ask for it to be.
> >
> May I ask, are you a lawyer?
No. As a programmer you must be just as vigilant about following
the rules as a lawyer is about following the law.
> It does not say, give the resultset randomized if two sort-arguments
> are the same.
If you write code this way you may run into problems in the future.
If the underlying engine is changed in the future and it produces
rows in a different order your program is now broken.
They specifically tell you it's not sorted if you don't specify
a sort order. It's trivial to have it sorted any way you desire
by adding an 'order by' clause. You're welcome to ignore their
advice if you desire though.
__________________________________
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
http://www.advision.webevents.yahoo.com/emoticontest
