Converting money types.

Поиск
Список
Период
Сортировка
Искать
От
Craig Anderson
Тема
Converting money types.
Дата
Msg-id
0104A6DCB4B2D2119660009027BC64510977B3@hpmail.netstatresources.com
Список
Hello,

	I have the following statement... select sum(p.priprice *
o.quantity) as total from products p, ordertemp o where o.orderid='xxxx' and
o.itemid=p.itemid; This statement returns something like $x,xxx.xx.
 
	The column p.priprice is of type money and o.quantity is of type
int4. Is there any way to modify that statement to return something like
xxxx.xx?

Craig Anderson
Director of Internet Services
Netstat Resources, LLC.
В списке pgsql-general по дате отправления
От: g.p.ciceri
Дата:
От: Michelle Murrain
Дата:
Сообщение: pg_dump problems
FAQ