enum_range()

Returns all values of the input enum type as an array

Arguments & returns

Scalar

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

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

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  enum_range(NULL::mood);