Jonathan Vanasco <postgres@xxxxxxxx> writes: > I'm trying to write a bit of logic as 1 query, but I can't seem to do > it under 2 queries. Uh, why can't you just push that CASE expression into the sub-select? UPDATE cart_item SET qty_requested_available = ( SELECT CASE WHEN qty_available > qty_requested THEN qty_requested ELSE qty_available END FROM stock where stock.id = stock_id ) ; You might have to qualify qty_requested here to make sure it comes from cart_item, if there's a column of the same name in stock. BTW, I'd suggest using GREATEST() instead of the CASE, but that's just a minor improvement. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
