Aggregate like AVG() with Money Data Type

Hello Friends

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

Thanks in Advance

Andr=E9
(Brazilian User)
=20
____________________________________________________________ ______________
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - =C9 gr=E1tis!
http://antipopup.uol.com.br/



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Aggregate like AVG() with Money Data Type

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/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend