RE: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Thomas, Basil
/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 be

Re: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Kurt Welgehausen
> 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 PR

Re: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread VTenneti
cc Subject Re: [sqlite] Exists keyword and corelated subq

Re: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Kurt Welgehausen
> 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 ---