Postgres append multiple elements to an array

Question

I have the following table in postgres with the below schema

Relations 

| id | tags |

I need to update the field tags to append unique multiple elements to it I can very well achieve it with like the below

for (String tagId : tagIds ) {

    // Execute the below query in PostGRES
    UPDATE Relations SET tags = array_append (array_remove (tags, '" + tagId + "'), '" + tagId + "') WHERE id = '" + id + "'";

}

But I want to append an array of elements to it in a single go without the for loop. Can someone let me know the query for that ?

Maybe: SELECT array_cat(ARRAY['a', 'b'], ARRAY['c', 'd']) --> {a,b,c,d} — Christiaan Westerbeek
– Christiaan Westerbeek, Commented Feb 11, 2019 at 14:05

Laurenz Albe · Accepted Answer · 2017-01-23 10:43:11Z

1

There is no simple solution.

Maybe that is an indication that you are abusing arrays and should store the tags in a table instead.

answered Jan 23, 2017 at 10:43

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

Postgres append multiple elements to an 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