From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Format an Update with calculation |
Date: | 2018-12-18 16:40:19 |
Message-ID: | a6d4bdea-4cc1-2728-7ce4-5135a41f6428@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bret,
That's just an example of how to use Postgres' cast syntax. You'd write:
UPDATE im_ci_item_transfer
SET suggested_retail_price=(suggested_retail_price +
(suggested_retail_price * .13))::numeric(7,2)
WHERE item_code='0025881P2';
I prefer the round() function, though.
On 12/18/2018 09:51 AM, Bret Stern wrote:
> Thanks again,
> I don't remember ever using a select in an update.
> Not sure how to use a select in an update, I'll google around.
>
>
> On Tue, 2018-12-18 at 08:18 +0100, Pavel Stehule wrote:
>>
>>
>> út 18. 12. 2018 v 8:15 odesílatel Bret Stern
>> <bret_stern(at)machinemanagement(dot)com> napsal:
>>
>> My statement below updates the pricing no problem, but I want
>> it to be
>> formatted with 2 dec points eg (43.23).
>>
>> Started playing with to_numeric but can't figure it out. Lots
>> of examples with to_char in the
>> manual, but still searching for answer.
>>
>> Can it be done?
>>
>>
>>
>> postgres=# select random();
>> ┌───────────────────┐
>> │ random │
>> ╞═══════════════════╡
>> │ 0.261391982901841 │
>> └───────────────────┘
>> (1 row)
>>
>> postgres=# select random()::numeric(7,2);
>> ┌────────┐
>> │ random │
>> ╞════════╡
>> │ 0.67 │
>> └────────┘
>> (1 row)
>>
>>
>>
>> Regards
>>
>>
>> Pavel
>>
>>
>>
>> I want suggested_retail_price to be formatted to 2 decimal
>> points
>>
>> UPDATE im_ci_item_transfer
>> SET suggested_retail_price=(suggested_retail_price +
>> (suggested_retail_price * .13))
>> WHERE item_code='0025881P2';
>>
>> Feeling lazy, sorry guys
>
>
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Howard News | 2018-12-18 16:59:29 | Problem with text search in Postgresql 10 |
Previous Message | Bret Stern | 2018-12-18 15:51:13 | Re: Format an Update with calculation |