format
A colour as a hex code, an rgb() tuple or an hsl() value, in CSS notation or, for hex and RGB, bare.
3 format types: none a sibling also accepts, 2 that decompose into parts.
The 3 format types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Color (Hexadecimal) color_hex · VARCHAR | #FF0000 | — |
Color (HSL) color_hsl · VARCHAR | hsl(120, 100%, 50%) | — |
Color (RGB) color_rgb · VARCHAR | rgb(255, 0, 0) | — |
Which format type is it?
1 of 3 format types accepts it.
| Type | Reads it as |
|---|---|
Color (Hexadecimal) color_hex | #FF0000 |
Use it
Shell
printf '%s\n' '#FF0000' '#f00' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('#FF0000'), ('#f00')) t(v);After #f00, one type remains: color_hex.