Suggestion for new development item of sqlite? I just mentioned this idea because of I thought that it is helpful for the others if it can be implemented.
Your answer is correct. But, n x n times of comparation would be occurred to count bigger number to set rank of each record in mytable can make this query to be slow. And, in my experience, there was some requirement of sequence number in my work area. Regards, Yongil Jang. 2013/2/5 Igor Tandetnik <i...@tandetnik.org> > On 2/4/2013 9:37 PM, Yongil Jang wrote: > >> For example, if sqlite supports sequence() function that returns current >> sequence number of result set then it can be used for this case, doesn't >> it? >> > > If SQLite supported such a function, then it could be used. But it > doesn't, so it can't. I'm not sure what point you are trying to make here. > > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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