Re: Aggregate like AVG() with Money Data Type

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "andre(dot)toscano" <andre(dot)toscano(at)uol(dot)com(dot)br>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Aggregate like AVG() with Money Data Type
Date: 2004-11-10 01:33:01
Message-ID: 20041110013301.GA52476@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ferindo Middleton Jr 2004-11-10 02:26:12 UPDATE/INSERT on multiple co-dependent tables
Previous Message Pierre-Frédéric Caillaud 2004-11-10 00:12:08 Re: Comparing two (largish) tables on different servers