-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Allan Schrum wrote: > Does any one know of a way to know which columns are to be used in a virtual > table implementation for a particular query?
There is an alternate approach. See http://www.sqlite.org/vtab.html#xcreate In particular if you declare a column to be HIDDEN then it won't be returned in queries unless the SQL explicitly asks for it. You can then declare all columns that are expensive to calculate as HIDDEN. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqX2NEACgkQmOOfHg372QQwnwCgh6a1Y77oxWDQ9NAFAElWO3x0 kA4An0XY++5SJpgSwlGI8R1B2arYKCjr =I+vY -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
