Partial replace in varchar array postgresql

The query below update joins by replacing the first intersection between Book.Tags and Temp.duplicateids with Temp.Id. This should work if max 1 intersection exists per pairs, because if the intersection is empty set, it will just evaluate to null and do not replace anything. However, if there could be multiple integers, then this will replace just the first match. If you want to replace all matches, then I recommend to implement a function that has a while loop, which, while there is at least an intersection does a replacement, until the intersection is empty set. But I refrained from doing that here for the sake of brevity. The query below was untested, let me know if there are any problems with it.

update Book
set Book.Tags = ARRAY_REPLACE(Book.Tags, (SELECT UNNEST(Book.Tags) INTERSECT SELECT UNNEST(Temp.duplicateids))[0], Temp.Id)
from Temp;

Sources:

• https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-update-join/
• https://www.commandprompt.com/education/array_replace-function-in-postgresql/
• Postgres - Function to return the intersection of 2 ARRAYs?
• Get Nth element of an array that returns from "string_to_array()" function