Update con select postgresql

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

Update from select postgresql

UPDATE
  <table1>
SET
  customer=subquery.customer,
  address=subquery.address,
  partn=subquery.partn
FROM
  (
    SELECT
      address_id, customer, address, partn
    FROM  /* big hairy SQL */ ...
  ) AS subquery
WHERE
  dummy.address_id=subquery.address_id;

Source: stackoverflow.com

Update con select postgresql

UPDATE dummy
SET customer=subquery.customer,
    address=subquery.address,
    partn=subquery.partn
FROM (SELECT address_id, customer, address, partn
      FROM  /* big hairy SQL */ ...) AS subquery
WHERE dummy.address_id=subquery.address_id;

Source: es.stackoverflow.com

Similar codes

3 votes186 views1 answer
Oracle detect invalid password
SQL
0 vote160 views1 answer
Mysql query with sql to get the next row
SQL
16 votes152 views6 answers
Install sqlite3 python
SQL
11 votes154 views2 answers
Turn off safe mode mysql
SQL
3 votes176 views2 answers
Search text in all sql server stored procedure
SQL
13 votes153 views1 answer
Select count of distinct values sql
SQL
0 vote161 views2 answers
Advantages of stored procedures sql
SQL
0 vote148 views1 answer
Insert or update sql query
SQL
10 votes150 views2 answers
Mysql alter add foreign key
SQL
0 vote152 views1 answer
Display first three characters sql
SQL