rate
2 rate types: none a sibling also accepts, 2 that decompose into parts.
The 2 rate types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Basis Points basis_points · VARCHAR | 125 bps | — |
Financial Yield / Return yield · VARCHAR | +2.5% | — |
Which rate type is it?
1 of 2 rate types accepts it.
| Type | Reads it as |
|---|---|
Basis Points basis_points | 0.0125 |
Use it
CLI · DuckDB
$ printf '%s\n' '125 bps' '25.5 bps' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('125 bps'), ('25.5 bps')) t(v);After 25.5 bps, one type remains: basis_points.