enum_code()

Returns the numeric value backing the given enum value

Arguments & returns

Scalar

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

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

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  enum_code('happy'::mood);