út 18. 12. 2018 v 8:15 odesílatel Bret Stern < bret_st...@machinemanagement.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 >
