MeridianMERIDIAN

discrete

A value from an ordered set, where the order means something: grades such as A, B and C, priority levels such as low, medium and high, star ratings or class rankings.

1 discrete type: Ordinal Value.

1 type

The discrete type

Ordinal Valueordinal
VARCHARhigh

Which discrete type is it?

Ordinal Value carries no pattern or format, so it has no rule to ask.

Use it

Shell
printf '%s\n' 'high' 'A' > column.txt
finetype infer -f column.txt --mode column
DuckDB
SELECT ft_profile(v) FROM (VALUES ('high'), ('A')) t(v);

No discrete type's rule accepts A.

Type Registry