Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregate like AVG() with Money Data Type - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Aggregate like AVG() with Money Data Type
Date
Msg-id 20041110013301.GA52476@winnie.fuhr.org
Whole thread Raw
In response to Aggregate like AVG() with Money Data Type  ("andre.toscano" <andre.toscano@uol.com.br>)
List pgsql-sql
Tree view 
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/

pgsql-sql by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Comparing two (largish) tables on different servers
Next
From: "Ferindo Middleton, Jr"
Date:
Subject: UPDATE/INSERT on multiple co-dependent tables