arrayspostgresqlpostgresql-17

How to remove last element from array?

I can remove easily the first element from an array:

SELECT (ARRAY[1,2,3])[2:]
--{2,3}

What is the simplest way to remove the last element as well ? The size is dynamic and is not known at compile time.

Solution

  • trim_array() is there since PostgreSQL 14:

    select (trim_array(array[1,2,3],1))[2:];