SQLite Forum

Possible Bug - View behaves differently to Table in SELECT
Login
That's quite a database! Thanks for the interesting schema.

Unrelated question, I've never seen the [] surrounding identifiers before, and I can't find them documented in the SQLite docs either. From experimenting, they seem the same as using double-quotes?

I see you mix their use, in your examples you use both `[e].[id]` and `e.id`. Is there a particular reason you use it?

Thanks,

Wout.