RE: [sqlite] Exists keyword and corelated subqueries
I think once SQLite ver 3.0 stabilizes, all of the enhancements to the SQL language capabilities will be addressed then. Once the the file format and low level engine enhancements are in production, I am sure many of us will want more compliant SQL code similar to SQL Server/Oracle/Sybase/MySQL/etc... but streamlined using the KISS principle that SQLite follows... -Original Message- From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:31 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Exists keyword and corelated subqueries > Any chance of their being added ... ? I doubt it; there have been lots of proposals for changes and additions flying around, but these points haven't come up (as best I can recall). Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.
Re: [sqlite] Exists keyword and corelated subqueries
> Any chance of their being added ... ? I doubt it; there have been lots of proposals for changes and additions flying around, but these points haven't come up (as best I can recall). Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Exists keyword and corelated subqueries
Thanks a lot for that, Kurt.
Any chance of their being added to SQLite anytime soon ?
Vijay
Kurt Welgehausen
<[EMAIL PROTECTED]>
To
16/04/2004 16:44 [EMAIL PROTECTED]
cc
Subject
Re: [sqlite] Exists keyword and
corelated subqueries
> EXISTS
No. Instead of 'where exists (select * ... )', use
'where (select count(*) ...) > 0'.
> cor[r]elated subqueries
No. They're called variable subqueries on the
Features-not-supported page.
> range variables, or are they host variables ?
Both. (Neither is supported.)
Regards
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Exists keyword and corelated subqueries
> EXISTS No. Instead of 'where exists (select * ... )', use 'where (select count(*) ...) > 0'. > cor[r]elated subqueries No. They're called variable subqueries on the Features-not-supported page. > range variables, or are they host variables ? Both. (Neither is supported.) Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
