Search Result: bogus - DuckDB 2.0 全文検索

Enum Data Type 9414: Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be ... a random (non-equivalent) string always results in false (and does not error): SELECT * FROM person WHERE current_mood = 'bogus'; -- Equivalent to `WHERE current_mood::VARCHAR = 'bogus'` -- No rows returned If you want to enforce type-safety, cast to ... the enum explicitly: SELECT * FROM person WHERE current_mood = 'bogus'::mood; -- Conversion Error: Could not convert string 'bogus' to ENUM('sad', 'ok', 'happy') Ordering of Enums Enum values ...; https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work