WITH rows AS (

SELECT table_order FROM contests WHERE id = item_id

)

UPDATE contests

set table_order = array_cat(

array_append(

(SELECT table_order[0:(array_position((SELECT table_order FROM rows), target) - 2)] FROM rows),

target

),

array_remove(

(SELECT table_order[(array_position((SELECT table_order FROM rows), target) - 1):100] FROM rows),

target

)

)

WHERE id = item_id AND target = ANY (table_order)


쓰레기 ㅁㅌㅊ?