Re: [sqlite] Boolean casting

On 15 Mar 2018, at 7:04pm, Jens Alfke wrote: > it would be nice if boolean could be elevated to a data type Agreed. And I think it could be done without breaking backward compatibility [1], just by implementing the string 'BOOLEAN' as a type. The value stored can be

Re: [sqlite] Boolean casting

> On Mar 15, 2018, at 11:20 AM, Simon Slavin wrote: > > It's possible, with a lot of work, to figure out whether the columns in a > table were defined as having type BOOLEAN. IF you want to do this tell us > and we'll tell you how. However, if you are doing a

Re: [sqlite] Boolean casting

On 15 Mar 2018, at 4:43pm, Pavan Paolo wrote: > I use in a view the following snip of code to force the results to be > considered as Boolean: SQLite does not have a BOOLEAN type. If you use the word BOOLEAN where it expects to see a type name it will use an affinity

[sqlite] Boolean casting

Dear all, I use in a view the following snip of code to force the results to be considered as Boolean: SELECT cast(start_processing_date is not null as BOOLEAN), ... I need this solution since in this way I can detect in java the Boolean data type by querying the ResultSet metadata