Hello developers! In this article I have shared the details about “postgres update with if condition query”. Okay, let’s move on to the tutorial.
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;
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;
I hope this article helps you to know about “postgres update with if condition query”. If you have any queries regarding this tutorial please let us know via the comment section. Share this article with your friends & family via social networks.