/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 vote154 views1 answer
How to make case insensitive in sql
SQL
0 vote261 views1 answer
Mysql select field if condition
SQL
0 vote159 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote153 views1 answer
Renommer table sql
SQL
0 vote147 views1 answer
Sql server select furst day of current year
SQL
5 votes738 views1 answer
Oracle ora-00054 find
SQL
2 votes151 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes161 views1 answer
Mac install mysql
SQL
0 vote152 views1 answer
Openquery insert into linked server
SQL
0 vote160 views1 answer
Oracle table privileges
SQL