remove a member of array in postgresql

Question

In Postgresql, if I have an array of team_id in my table for example team_id=[2,3,5,7] when I want to remove 7 from the array of team_id what is the command?

I write :

SELECT array_remove(ARRAY[team_id],7)

but it is not correct

Gordon Linoff · Accepted Answer · 2020-01-25 17:51:31Z

2

The array keyword is unnecessary:

select array_remove(team_id, 7)

answered Jan 25, 2020 at 17:51

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

remove a member of array in postgresql

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