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
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
"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
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
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
--
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
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
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.
8 matches
Mail list logo