Hi, all,
is there a syntactical construct which will allow me to use a pragma in a
subselect? e.g. i'm trying to do...
sqlite> pragma table_info(vfile);
cid|name|type|notnull|dflt_value|pk
0|id|INTEGER|0||1
1|vid|INTEGER|0||0
...
sqlite> select name from (pragma table_info(vfile));
Error: near "(": syntax error
sqlite> select name from pragma table_info(vfile);
Error: near "(": syntax error
sqlite> create view v as pragma table_info(vfile);
Error: near "pragma": syntax error
sqlite> create view v as select (pragma table_info(vfile));
Error: near "table_info": syntax error
sqlite> create view v as select pragma table_info(vfile);
Error: near "(": syntax error
Is this possible?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
