/etc... but streamlined using
principle that SQLite follows...
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
> 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).
To unsubscribe, e-mail: [EMAIL
No. Instead of 'where exists (select * ... )', use
'where (select count(*) ...) > 0'.
> cor[r]elated subqueries
No. They're called variable subqueries on the
> range variables, or are they host variables ?
Both. (Neither is supported.)
Mail list logo