mhiro216
Reputation: 91
Query to replace partial values in an array of int in PostgreSQL
In PotgreSQL, how do I write a query to replace some values in an int4 array?
{1,2,10} -> {1,2,999}
{2,3,10} -> {2,3,999}
is what we are aiming for.
Upvotes: 0
Views: 115
Answers (1)
Popeye
Reputation: 35910
Seems like you want to replace 10 with 999, you can use array_replace
array_replace(your_column, 10, 999)
Upvotes: 2
Related Questions
- How to replace a value in array
- Postgres replace function with an array of values
- How to replace an array of characters in a column of text in PostgreSQL?
- Modify column value in postgresql
- Postgres array_replace() function to replace sub array
- Alter column from Integer[] (ARRAY) to Integer in Postgres
- Replace column integer values with matching strings in PostgreSql
- PostgreSQL: Replace values greater than a certain limit in array elements
- Update multiple values from an array with array_replace()
- Updating an array and converting from varchar to integer