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 encoded the same as integ
> 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 calculation in a SELECT
> like
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 of NUMBER. See sections
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 rs.getMetaDat
4 matches
Mail list logo