postgres update return new values and old values

query.sql

-- returning updated values and old values by using a sub-expression

update orders
  set type = 'delivery'
  where id = 3767
  returning id, type, (
    select type from orders where id = 3767
  ) as old_type;