Hello Igor Tandetnik, > 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.
Perfect --- just what I need. Sqlite is quite amazing... Sven -- __ _ _ __ __ __ / _` || ' \ \ \ / http://www.svenutcke.de/ \__, ||_|_|_|/_\_\ http://www.dr-utcke.de/ |___/ Key fingerprint = 6F F8 55 1C F9 E3 A8 F7 09 DF F7 2C 25 0C 54 53 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
