Postgres Pro
Downloads
Home   >   mailing lists

Format an Update with calculation - Mailing list pgsql-general

From Bret Stern
Subject Format an Update with calculation
Date
Msg-id 1545117297.4397.18.camel@dell990-bret-centos.localdomain
Whole thread Raw
Responses Re: Format an Update with calculation  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Format an Update with calculation  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Re: Format an Update with calculation  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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?

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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: IF NOT EXIST
Next
From: Pavel Stehule
Date:
Subject: Re: Format an Update with calculation