On 6/17/2011 6:11 PM, Sven Utcke wrote: > Actually, the above would be awfully slow (as it can not use the > index). It might be better to use an intermediate table (but of > course still filled using urldecode()), what is the recommended way to > create such a table in sqlite3 (and have it dropped on exit)?
create temp table decoded(decodedUrl); insert into decoded(decodedUrl) select urldecode(name) from "table"; You can create indexes on temp table - they will be dropped together with the table when you close the connection. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users