Re: Format an Update with calculation

ú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
>