/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

2 votes171 views1 answer
Latest record in sql
SQL
0 vote197 views1 answer
Postgres select except
SQL
0 vote210 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote223 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote193 views1 answer
Oracle create program if no exists
SQL
0 vote213 views1 answer
Sql get number of days between two dates
SQL
0 vote210 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes285 views1 answer
Apex call duration
SQL
1 vote199 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote216 views1 answer
Regular expression in sql server
SQL