boolean
A true-or-false value written as a digit, an initial or a word: zero and one, T and F or Y and N, or true and false, yes and no. finetype turns each into a DuckDB BOOLEAN.
3 boolean types: none a sibling also accepts, 1 in Meridian's open data.
The 3 boolean types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Binary Boolean (0/1) binary · BOOLEAN | 0 | — |
Boolean Initials (T/F, Y/N) initials · BOOLEAN | T | — |
Boolean Terms (True/False, Yes/No) terms · BOOLEAN | true | — |
Which boolean type is it?
Binary Boolean (0/1), Boolean Initials (T/F, Y/N) and Boolean Terms (True/False, Yes/No) carry no pattern or format, so they have no rule to ask.
In Meridian's datasets
- Boolean Terms (True/False, Yes/No)gleif
.entity_statusschedule_b.agriculturalndc.sample
Use it
Shell
printf '%s\n' '0' '1' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('0'), ('1')) t(v);No boolean type's rule accepts 1.