update with select

Started by Cristóvão Dalla Costaabout 23 years ago2 messagesgeneral

cbraga@bsi.com.br

about 23 years ago

Hi,

Is it possible to rewrite this query to use a single SELECT?

UPDATE product SET
price_min = (SELECT min (price) FROM subproduct WHERE subproduct.product
= $ID),
price_max = (SELECT max (price) FROM subproduct WHERE subproduct.product
= $ID)
WHERE id = $ID

Thanks.

Jean-Luc Lachance

jllachan@nsd.ca

about 23 years ago

In reply to: Cristóvão Dalla Costa (#1)

Re: update with select

Try:

UPDATE product SET price_min = ss.min_price, price_max = ss.max_price
from ( select min( price) as min_price, max( price) as max_price
FROM subproduct WHERE subproduct.product = $ID) as ss
WHERE id = $ID;

"Cristóvão B. B. Dalla Costa" wrote:

Show quoted text

Hi,

Is it possible to rewrite this query to use a single SELECT?

UPDATE product SET
price_min = (SELECT min (price) FROM subproduct WHERE subproduct.product
= $ID),
price_max = (SELECT max (price) FROM subproduct WHERE subproduct.product
= $ID)
WHERE id = $ID

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org