You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The text was updated successfully, but these errors were encountered:
rpbouman
changed the title
Issue found on page 'Enum Data Type': Would be good to mention you can CAST to implicit ENUM which does not require CREATE TYPE
Issue found on page 'Enum Data Type': Would be good to mention you use anonymous ENUM types in CAST operations (without CREATE TYPE)
Dec 24, 2024
The ENUM data type page currently suggests you need to create the ENUM type explicitly using CREATE TYPE.
However, it is possible to use anonymous ENUMs in CAST expressions, in which case no CREATE TYPE statement is required beforehand:
SELECT 'ok'::ENUM ('sad', 'ok', 'happy') as mood
It would be good to mention this syntax.
Page URL: https://duckdb.org/docs/sql/data_types/enum.html
The text was updated successfully, but these errors were encountered: