Postgres Pro
Downloads
Home   >   mailing lists

Re: trying to write a bit of logic as one query, can't seem to do it under 2 - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: trying to write a bit of logic as one query, can't seem to do it under 2
Date
Msg-id 6C745CB3-183F-4937-8C96-FA22D46133E5@2xlp.com
Whole thread Raw
In response to Re: trying to write a bit of logic as one query, can't seem to do it under 2  (Glen Parker <glenebob@nwlink.com>)
Responses Re: trying to write a bit of logic as one query, can't seem to do it under 2  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Tree view 
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);

pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Re: trying to write a bit of logic as one query, can't seem to do it under 2
Next
From: Scott Mead
Date:
Subject: Re: Identical command-line command will not work with \i metacommand and filename