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:

On Tue, Dec 5, 2017 at 8:28 AM Flavio Pompermaier <> wrote:
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:
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 difficult to support it?


Flavio Pompermaier
Development Department

OKKAM S.r.l.
Tel. +(39) 0461 041809