WITH
"old_data" AS (
SELECT
"id",
"colour"
FROM
"random_table"
WHERE
"random_table"."id" IN (643)
)
UPDATE "random_table" AS "ti"
SET
"colour" = 'blue'
FROM
"old_data" AS "od"
WHERE
"ti"."id" = "od"."id"
RETURNING
"ti"."id",
"ti"."status",
"od"."status" AS "old_status"
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)