Yes, you can sort by * > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Tony Papadimitriou > Sent: Monday, 1 July, 2013 05:23 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Is there a way to return the row number? (NOTthe > rowid) > > Please! Just because you can select something doesn't mean you have > to be > able to sort by it. Can you sort by * > (select * by table sort by *)? So, why make it sound like I don't > know what > I'm talking about? > > -----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