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.getMetaData().getColumnType() and trigger a proper visualization in a table. Anyway, this cause to get column name a bit messy, reporting the "CAST(non_compliant ..." itself as title of the column. If I try to use an alias such as the following, I fix the title but I loose the Boolean data type. select cast(start_processing_date is not null as BOOLEAN) as my_check_name, ... Is this behavior expected? How I can work on it? Thank you, Paolo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users