it would be that, but with greatest
thank you. that's the exact query i was failing to write !
On Apr 21, 2010, at 8:51 PM, Glen Parker wrote:
> UPDATE
> cart_item
> SET
> qty_requested_available = least(cart_item.qty_requested,
> stock.qty_available)
> FROM
> stock
> WHERE
> cart_item.stock_id = stock.stock_id AND
> qty_requested_available <> least(cart_item.qty_requested,
> stock.qty_available);