On Mon, 01 Jul 2013 13:10:59 +0200 Gabriel Corneanu <gabrielcorne...@gmail.com> wrote:
> I also needed this for some special update queries. > Without many details, it was some kind of "insert into xxx select > <row()>, otherfields from source order by <custom function>". > For this case there is a workaround, selecting first into a temporary > table with auto generated rowid and using it afterwards for insert. Ranking the rows requires nothing more than joining the table to itself. You might find http://www.schemamania.org/sql/#rank.rows helpful. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
