Re: Format an Update with calculation
От
Andrew Gierth
Тема
Re: Format an Update with calculation
Дата
Msg-id
87pntzvtip.fsf@news-spur.riddles.org.uk
Ответ на
Format an Update with calculation (Bret Stern)
Список
Дерево обсуждения
Format an Update with calculation Bret Stern <bret_stern@machinemanagement.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>
Re: Format an Update with calculation Condor <condor@stz-bg.com>
Re: Format an Update with calculation Ron <ronljohnsonjr@gmail.com>
Re: Format an Update with calculation Ken Tanzer <ken.tanzer@gmail.com>
Re: Format an Update with calculation Pavel Stehule <pavel.stehule@gmail.com>
Re: Format an Update with calculation Bret Stern <bret_stern@machinemanagement.com>
Re: Format an Update with calculation Ron <ronljohnsonjr@gmail.com>
>>>>> "Bret" == Bret Stern writes: Bret> My statement below updates the pricing no problem, but I want it Bret> to be formatted with 2 dec points eg (43.23). UPDATE ... SET suggested_retail_price = round(suggested_retail_price*1.13, 2) WHERE ... assuming suggested_retail_price is already of type "numeric". You could also have given the columm a type of numeric(18,2) or similar, which would round all assigned values to 2 places. -- Andrew (irc:RhodiumToad)
В списке pgsql-general по дате отправления
