Right, my bad, thanks Tyler for the correction.
On Tue, Sep 30, 2014 at 5:44 PM, Tyler Hobbs wrote:
> I think Sylvain may not have had his coffee yet. You can't use IF's in
> SELECT statements, but you can in INSERT/UPDATE/DELETE:
>
> UPDATE foo SET a = 0 WHERE k = 0 IF b != 0;
>
> On Tue, Sep
I think Sylvain may not have had his coffee yet. You can't use IF's in
SELECT statements, but you can in INSERT/UPDATE/DELETE:
UPDATE foo SET a = 0 WHERE k = 0 IF b != 0;
On Tue, Sep 30, 2014 at 2:36 AM, Sylvain Lebresne
wrote:
>
>
>> Is != supported as part of the where clause in Cassandra?
>
>
> Is != supported as part of the where clause in Cassandra?
>
It's not.
Or is it the grammar for some other purpose?
>
It's supported in 'IF' conditions. You can do something like:
SELECT * FROM foo WHERE k = 0 IF v != 3;
--
Sylvain
Looking through the CQL 3.1 grammar for Cassandra 2.1, I noticed that the
not-equals operator (!=) is in the grammar definition, but I can't seem to
find any legal way to use it.
Is != supported as part of the where clause in Cassandra? Or is it the
grammar for some other purpose?
