enum_first()

Returns the first value of the input enum type

Arguments & returns

Scalar

Overload link	`enum`	Returns
#01	`ANY`	`VARCHAR`

CREATE OR REPLACE TYPE example_mood AS ENUM ('sad', 'neutral', 'happy');
SELECT enum_first(NULL::example_mood) AS result;

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  enum_first(NULL::mood);