binding of boolean literals in SQL

2021-11-16 Thread Gavin Nicol
I'm writing a FilterableTable implementation and so far all is well. When handling more complex filters I've come across the need to pass in a boolean flag via a filter clause, something like: select "foo" from "bar" where "clean"=true and "id"='1234' This results in a filter like: AND(CAS

Re: binding of boolean literals in SQL

2021-11-16 Thread Julian Hyde
It’s possible, and I would think desirable, to simplify “clean” = true and for that matter “clean” is true to “clean” and based on your experiments it looks as if we do it already. Julian > On Nov 16, 2021, at 18:06, Gavin Nicol wrote: > > I'm writing a FilterableTable implementa