Updating Data

UPDATE customers SET full_name = 'Alice W.'
WHERE id = 42;

UPDATE customers
   SET full_name = 'Alice W.', phone = '+1 555 0100', updated_at = now()
 WHERE id = 42;

UPDATE orders SET status = 'cancelled'
WHERE status = 'new'
  AND placed_at < now() - interval '7 days';

UPDATE settings SET version = version + 1;

UPDATE orders o
   SET total_cents = li.total
  FROM (SELECT order_id, SUM(price_cents*qty) AS total
          FROM order_items GROUP BY order_id) li
 WHERE li.order_id = o.id;

UPDATE customers
   SET tier = (SELECT tier FROM tier_rules WHERE customers.spend >= min_spend
                ORDER BY min_spend DESC LIMIT 1);

UPDATE orders SET status='shipped', shipped_at=now()
WHERE id = 1001
RETURNING id, status, shipped_at;

UPDATE events
   SET payload = jsonb_set(payload, '{status}', '"processed"', true)
 WHERE id = 7;
UPDATE events SET payload = payload - 'temp_field';
UPDATE events SET payload = payload || '{"v":2}'::jsonb;

UPDATE posts SET tags = array_append(tags, 'new')           WHERE id=1;
UPDATE posts SET tags = array_remove(tags, 'old')           WHERE id=1;
UPDATE posts SET tags[2] = 'replacement'                    WHERE id=1;
UPDATE posts SET tags = array_replace(tags,'old','new')     WHERE id=1;

UPDATE customers
   SET tier = CASE
       WHEN spend >= 10000 THEN 'platinum'
       WHEN spend >= 1000  THEN 'gold'
       ELSE 'standard'
   END;