PostgreSQL Enum Functions

An enumeration is a type that defines a finite number of constants, and this page organizes enumeration functions in PostgreSQL.

  1. enum_first

    The PostgreSQL enum_first() function returns the first enum value of the enum type specified by the parameter.

  2. enum_last

    The PostgreSQL enum_last() function returns the last enum value of the enum type specified by the parameter.

  3. enum_range

    The PostgreSQL enum_range() function returns all enumeration values ​​of the enumeration type specified by the parameter, or the enumeration values ​​in the specified range.