Re: [sqlite] Exists keyword and corelated subqueries

[VTenneti]

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]