Functions/Database & utility/enum_range_boundary
Database & utility Scalar

enum_range_boundary()

Returns the range between the two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL, the result starts with the first value of the enum type. When the second parameter is NULL, the result ends with the last value of the enum type

Arguments & returns

enum_range_boundary(start, end)

Scalar
Overload link startend Returns
#01 ANYANY VARCHAR[]

Example

enum_range_boundary example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

Catalog examples

SELECT
  enum_range_boundary(NULL, 'happy'::mood);