Re: [sqlite] Version 3.0.0 ALPHA now available

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 ?

RE: [sqlite] SQLite version 3 design question: '500'=500?

Not only comparison, but all expressions - arithmetic etc. [EMAIL PROTECTED] com

RE: [sqlite] SQLite version 3 design question: '500'=500?

Ditto that. [EMAIL PROTECTED] com

RE: [sqlite] SQLite version 3 design question: '500'=500?

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 Relational Calculus. To say types and strong typing weren't part of the original SQL concept isn't right. Typing gives data semantics. Vijay

Re: [sqlite] suggestion

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 greatly. Vijay - Forwarded by Vijay S Tenneti/Europe/Group 1 Software Europe Ltd on 21/04/2004 18:46 -

[sqlite] Timeframe for 3.0 ?

Hi, 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

[sqlite] Exists keyword and corelated subqueries

Hi, 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