PostgreSQL - Delete last item of JSONB array

Question

I have a field that holds JSONB arrays. How can I delete the last item?

[
  {
    "name": "test1",
  },
  {
    "name": "test2",
  },
]

Marth · Accepted Answer · 2022-02-12 19:12:21Z

2

You can use jsonb_column - (-1). See the documentation.

WITH data(j) AS (
    VALUES ('[
      {
        "name": "test1"
      },
      {
        "name": "test2"
      },
      {
        "name": "test3"
      }
    ]'::JSONB)
)
SELECT j, j - (-1) AS all_but_last, j - 1 AS without_second_element
FROM data;

j	all_but_last	without_second_element
[{"name":"test1"},{"name":"test2"},{"name":"test3"}]	[{"name":"test1"},{"name":"test2"}]	[{"name":"test1"},{"name":"test3"}]

View on DB Fiddle

answered Feb 12, 2022 at 19:12

Marth

24.9k3 gold badges68 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL - Delete last item of JSONB array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related