Ok, fine for me :) Thanks for the discussion anyway On Tue, Dec 5, 2017 at 5:54 PM, James Taylor <[email protected]> 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 IS true or column IS 4 as some kind of alternative to using > an equality expression. More on that here: https://stackoverflow. > com/questions/859762/is-this-the-proper-way-to-do-boolean-test-in-sql > > On Tue, Dec 5, 2017 at 8:28 AM Flavio Pompermaier <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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? >>>> >>>> Best, >>>> Flavio >>>> >>> >> >> >> -- >> Flavio Pompermaier >> Development Department >> >> OKKAM S.r.l. >> Tel. +(39) 0461 041809 <+39%200461%20041809> >> > -- Flavio Pompermaier Development Department OKKAM S.r.l. Tel. +(39) 0461 041809
