postgresql - Remove array values in pgSQL

Question

Is there a way to remove a value from an array in pgSQL? Or to be more precise, to pop the last value? Judging by this list the answer seems to be no. I can get the result I want with an additional index pointer, but it's a bit cumbersome.

question from:https://stackoverflow.com/questions/2072776/remove-array-values-in-pgsql

Answer 1

No, I don't think you can. At least not without writing something ugly like:

SELECT ARRAY (
 SELECT UNNEST(yourarray) LIMIT (
  SELECT array_upper(yourarray, 1) - 1
 )
)