Any chance of getting Correlated Subqueries, including the EXISTS / NOT
EXISTS clause ?
And since it is open season, could we have user defined expression
evaluation functionality (other than user defined compares that 3.0 already
has). For example arithmetic, substring etc ?
Not only comparison, but all expressions - arithmetic etc.
Funny, I thought SQL was a more down to earth version of E. F. Codd's
mathematical model 'Relational Algebra', with some concepts taken from
To say types and strong typing weren't part of the original SQL concept
isn't right. Typing gives data semantics.
Don't know about ALTER TABLE, but having native corelated subqueries
support would save on code and possibly speed up getting at the end result
- Forwarded by Vijay S Tenneti/Europe/Group 1 Software Europe Ltd on
21/04/2004 18:46 -
We're considering the use of SQLite in the next version of our Doc1
product. SQLite does seem the ideal embedded database for us to use.
However, there seem to a couple of thorny issues, and can someone please
throw some light on they could possibly be resolved:
1. Our product is Unicode
Can anyone please tell me if 'EXISTS' is supported (for subqueries in the
WHERE clause) and also if corelated subqueries are supported ?
One more thing: on the 'features not supported' page, the second point
mentions variables not being supported in queries: are these 'corelation
Mail list logo