-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 25/01/13 12:57, Petite Abeille wrote: > and lower( sql ) like '% virtual %'
It is worth pointing out that SQLite normalises the create table text for a table in the sqlite_master table. ie it always begins "CREATE VIRTUAL TABLE" (uppercased) no matter how the table was created. By contrast the columns are left exactly as they were, whitepspace, comments and all. DDL: create /* foo */ vIrTual table foo using fts3(content /* ab */ TEXT); Corresponding sqlite_master: CREATE VIRTUAL TABLE foo using fts3(content /* ab */ TEXT) Of course this is an implementation detail and not specified anywhere, but it is good enough. Your like query has the problem that it will match rows where virtual appears anywhere. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlEECw8ACgkQmOOfHg372QRNTwCgrYP5vGFvPHlvnauTv1u6e1Mu xeIAn1t5fJLIvFna1Ndf+Jf42AHud0ev =pwfQ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
