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 vote166 views1 answer
Java sql insert return id
SQL
0 vote191 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
15 votes173 views2 answers
How to drop database name in postgresql
SQL
25 votes183 views4 answers
Sqlserver add column
SQL
14 votes186 views4 answers
Online sql compiler
SQL
1 vote178 views2 answers
Mysql update table from another table
SQL
3 votes168 views1 answer
Oracle wait
SQL
8 votes168 views1 answer
Today minus 15 days postgresql
SQL
1 vote188 views1 answer
Sql find column name like
SQL
1 vote186 views1 answer
Alter constraint in sql
SQL