How to update an array of boolean (flags)?

You need to upgrade to a "Type" element at index. Help to do this effectively.
What I want is something like
if 1 = 2 then "Type"[1] = TRUE
if 1 = 1 then "Type"[2] = TRUE

UPDATE "Test"
SET "Type" = (
CASE
 WHEN 1 = 2 THEN "Type"[1] = TRUE
 WHEN 1 = 1 THEN "Type"[2] = TRUE
END
)
June 10th 19 at 15:37
0 answer

Find more questions by tags SQL ServerPostgreSQLSQL