Re: Boolean condition doesn't support IS operator

[Flavio Pompermaier]

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 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 
> 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?

 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

Re: Boolean condition doesn't support IS operator

[James Taylor]

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 
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?
>>>
>>> Best,
>>> Flavio
>>>
>>
>
>
> --
> Flavio Pompermaier
> Development Department
>
> OKKAM S.r.l.
> Tel. +(39) 0461 041809
>

Re: Boolean condition doesn't support IS operator

[Flavio Pompermaier]

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?
>>
>> Best,
>> Flavio
>>
>


-- 
Flavio Pompermaier
Development Department

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

Re: Boolean condition doesn't support IS operator

[James Taylor]

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?
>
> Best,
> Flavio
>

Boolean condition doesn't support IS operator

[Flavio Pompermaier]

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