Re: Boolean condition doesn't support IS operator

Ok, fine for me :) Thanks for the discussion anyway On Tue, Dec 5, 2017 at 5:54 PM, James Taylor wrote: > In SQL, you use IS with NULL or NOT NULL as a way to test for null since > column = NULL will never return true. I’ve never seen a SQL dialect that > allows column

Re: Boolean condition doesn't support IS operator

In SQL, you use IS with NULL or NOT NULL as a way to test for null since column = NULL will never return true. I’ve never seen a SQL dialect that allows column IS true or column IS 4 as some kind of alternative to using an equality expression. More on that here:

Re: Boolean condition doesn't support IS operator

At the moment I'm usign VALID = true but IMHO Phoenix should support the IS syntax for boolean columns as well..of course this is just a +1 on this topic If no other one ask for this feature you could ignore this :) On Tue, Dec 5, 2017 at 4:31 PM, James Taylor wrote: >

Re: Boolean condition doesn't support IS operator

How about just using VALID = true or just VALID like this: select * from t where VALID On Tue, Dec 5, 2017 at 2:52 AM Flavio Pompermaier wrote: > Hi to all, > I'm using Phoenix 4.7 and I cannot use IS operator on boolean values (e.g. > VALID IS TRUE) > Would it be that

Boolean condition doesn't support IS operator

Hi to all, I'm using Phoenix 4.7 and I cannot use IS operator on boolean values (e.g. VALID IS TRUE) Would it be that difficult to support it? Best, Flavio