Re: [sqlite] Temp views and sqlite_temp_master

2010-07-08 Thread Jay A. Kreibich
On Wed, Jul 07, 2010 at 08:20:13PM -0500, Jon Polfer scratched on the wall: > I'm currently running SQLite 3.5.9. > > I've been experimenting around with temporary views, and discovered > that: > > a) They don't appear in sqlite_master after you create them; they do > however appear in a (I beli

Re: [sqlite] Temp views and sqlite_temp_master

2010-07-08 Thread Simon Davies
On 8 July 2010 02:20, Jon Polfer wrote: > I'm currently running SQLite 3.5.9. > > I've been experimenting around with temporary views, and discovered > that: > > a)  They don't appear in sqlite_master after you create them; they do > however appear in a (I believe undocumented) table called > sqli

[sqlite] Temp views and sqlite_temp_master

2010-07-08 Thread Jon Polfer
I'm currently running SQLite 3.5.9. I've been experimenting around with temporary views, and discovered that: a) They don't appear in sqlite_master after you create them; they do however appear in a (I believe undocumented) table called sqlite_temp_master that I found by running an EXPLAIN on th