enum_range

Returns all values of the input enum type in an ordered array.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: enum
group label: Enum Support Functions
lang: en
layout: table-new
pages: functions-enum.html
prose only: false

Definition PG 18

Returns all values of the input enum type in an ordered array.

Signatures and overloads

enum_range ( anyenum ) → anyarray → anyarray

Returns all values of the input enum type in an ordered array.

enum_range ( anyenum, anyenum ) → anyarray → anyarray

Returns the range between the two given enum values, as an ordered array. The values must be from the same enum type. If the first parameter is null, the result will start with the first value of the enum type. If the second parameter is null, the result will end with the last value of the enum type.

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:6da129424c3a1cdef95aad69b0cd9268bca6754d4f80470bdecaa1edd37e93b3

Text language: en · wiki-repair-20261023:6da129424c3a1cdef95aad69b0cd9268bca6754d4f80470bdecaa1edd37e93b3