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

0 vote163 views1 answer
Django how to get query result count
SQL
24 votes172 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote202 views1 answer
OFFSET consulta mysql
SQL
2 votes251 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote178 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote198 views1 answer
Sql case sttement with set
SQL
0 vote196 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote197 views1 answer
Oracle update with sequence
SQL
3 votes198 views2 answers
Get current year sql
SQL
0 vote205 views1 answer
Sql server get date of previous sunday
SQL