[sqlite] Number of elements in IN clause

2008-01-28 Thread Felix Radensky
Hi, Is there any limitation on the number of elements in IN clause ? Can one have, e.g. thousands of elements ? Also, can having to many elements become inefficient at some point and one has to use some other technique, i.e. comparing elements one by one in a loop ? Thanks in advance. Felix.

RE: [sqlite] Number of elements in IN clause

2008-01-28 Thread RB Smissaert
g Subject: Re: [sqlite] Number of elements in IN clause Felix Radensky <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any limitation on the number of elements in IN clause ? > Can one have, e.g. thousands of elements ? Also, can having > to many elements become inefficient at so

Re: [sqlite] Number of elements in IN clause

2008-01-28 Thread drh
Felix Radensky <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any limitation on the number of elements in IN clause ? > Can one have, e.g. thousands of elements ? Also, can having > to many elements become inefficient at some point and one > has to use some other technique, i.e. comparing elements

Re: [sqlite] Number of elements in IN clause

2008-01-28 Thread drh
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > I don't think it is standard SQL. At the very least, it doesn't work in > MSSQL. Standard is > > SELECT * FROM maintable WHERE key IN (select x from stuff); > > SQLite shortened version is much nicer.. wish it was standard. > SQLite also acc

RE: [sqlite] Number of elements in IN clause

2008-01-28 Thread Fowler, Jeff
his notation, but it does make sense. It would be nice if it matched on field name, that way the same syntax could be used in both cases. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 28, 2008 9:20 AM To: sqlite-users@sqlite.org Subject: Re

RE: [sqlite] Number of elements in IN clause

2008-01-28 Thread Fowler, Jeff
e.org Subject: Re: [sqlite] Number of elements in IN clause Felix Radensky <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any limitation on the number of elements in IN clause ? > Can one have, e.g. thousands of elements ? Also, can having to many > elements become inefficien

RE: [sqlite] Number of elements in IN clause

2008-01-28 Thread Samuel R. Neff
rg Subject: Re: [sqlite] Number of elements in IN clause "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > I don't think it is standard SQL. At the very least, it doesn't work in > MSSQL. Standard is > > SELECT * FROM maintable WHERE key IN (select x fr

RE: [sqlite] Number of elements in IN clause

2008-01-28 Thread Samuel R. Neff
sers@sqlite.org Subject: RE: [sqlite] Number of elements in IN clause >SELECT * FROM maintable WHERE key IN stuff; Thanks for that tip. Didn't know you could do that. Can't remember this as standard SQL. RBS --