Home > mailing lists

update with select - Mailing list pgsql-general

From	Cristóvão B. B. Dalla Costa
Subject	update with select
Date	January 9, 2003 20:04:00
Msg-id	3E1DF175.8040600@bsi.com.br Whole thread Raw
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: Tom Lane
Date: 09 January 2003, 20:03:09
Subject: Re: Version Problems on Mac OS X.2 Jaguar

From: Brian Hirt
Date: 09 January 2003, 20:15:25
Subject: Re: Version Problems on Mac OS X.2 Jaguar

update with select - Mailing list pgsql-general

Previous

Next