big stone wrote: > There is a non-logicality of having "pragma table_info(my_table)" : > - answering like a select, > - but being not usable as a "select", nor queriable by a "select".
SQLite's PRAGMA implementations do not plug into the internal query mechanism used by SELECT, but hardcode a VDBE program that directly generates the output as seen by sqlite3_step/column_xxx. There is no built-in mechanism that would allow to use the output of a VDBE program directly as input for other queries. (But it is possible to write a virtual table that does this.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users