update a fiedl in postgres with if condition code example

Example 1: postgres update with if condition query

update t1 
  set current_location = 
    case t2.status
        when 0 then 'Deployed'
        when 1 then 'Retrieved'
        when 2 then 'Lost'
    end
from t2 inner join t3
   on t2.some_id = t3.some_id
where t3.serial_number = t1.serial_number;

Example 2: posgres update syntax

UPDATE table
SET column1 = value1,
    column2 = value2 ,...
WHERE
	condition;

Tags:

Sql Example

Related