> Please! Just because you can select something doesn't mean you have to be > able to sort by it.
There are a small number of exceptions, each of which is a bodge. But some bodges are worth the impact. > Can you sort by * * is a very useful and largely harmless bodge. There is fundamentally no reason why you shouldn't be able to to sort by *. But people usually care about the order of field in a sort. > (select * by table sort by *)? I'm sure there will be a SQL engine somewhere that will do it for you. It would require no additional documentation or code. In fact it might require extra, to prevent it. It's pointless, but benign. > So, why make it sound like I don't know what I'm talking about? I think you beat me to it. > > -----Original Message----- From: Alex Bowden > Sent: Monday, July 01, 2013 2:07 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Is there a way to return the row number? (NOTthe rowid) > >> This would not be something you would sort by. > > And what if I do? > >> It should be assigned a value only during final 'display' of the query after >> all 'sorts' of operations are done with. > > Oh great. So the user is supposed to understand the implementation, in order > to understand what the results will be. > > > This would be just another nail in the coffin of relationality and > simplicity, on a minor whim. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users