Обсуждение: Aggregate like AVG() with Money Data Type

Поиск
Список
Период
Сортировка

Aggregate like AVG() with Money Data Type

От
"andre.toscano"
Дата:
Hello Friends

How can I use the aggregate AVG() with a column MONEY?

Thanks in Advance

André
(Brazilian User)
__________________________________________________________________________
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - É grátis!
http://antipopup.uol.com.br/




Re: Aggregate like AVG() with Money Data Type

От
Michael Fuhr
Дата:
On Tue, Nov 09, 2004 at 06:40:53PM -0200, andre.toscano wrote:

> How can I use the aggregate AVG() with a column MONEY?

The MONEY type has been deprecated since at least PostgreSQL 7.0.
Is there a reason you're not using NUMERIC?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/