/SQL/Postgres update with if condition query

Postgres update with if condition query

update t1
        set t1.current_location =   
        CASE  
			WHEN SUBQUERY.status = 0 THEN 'Deployed' 
			WHEN SUBQUERY.status = 1 THEN 'Retrieved' 
			WHEN SUBQUERY.status = 2 THEN 'Lost' 
            ELSE t1.current_location
		END 
from (
    select t3.serial_number, t2.status
    from t2 inner join t3
        on t2.some_id = t3.some_id
    ) as SUBQUERY

where SUBQUERY.serial_number = t1.serial_number;

Source: stackoverflow.com

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;

Source: stackoverflow.com

Similar codes

0 vote315 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote309 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote333 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
7 votes305 views1 answer
Sql server convert string to date
SQL
0 vote315 views1 answer
Sql insert query list of dictionaries
SQL
-1 vote287 views1 answer
How to use update trigger in sql
SQL
0 vote318 views2 answers
Uninstall postgresql mac
SQL
6 votes296 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote292 views1 answer
Temp table vs variable table in sql server
SQL
2 votes319 views2 answers
Storing timezones in postgres
SQL