pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Aggregate like AVG() with Money Data Type
2+ messages / 2 participants
[nested] [flat]

* Aggregate like AVG() with Money Data Type
@ 2004-11-09 20:40 andre.toscano <andre.toscano@uol.com.br>
  2004-11-10 01:33 ` Re: Aggregate like AVG() with Money Data Type Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: andre.toscano @ 2004-11-09 20:40 UTC (permalink / raw)
  To: pgsql-sql

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/





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Aggregate like AVG() with Money Data Type
  2004-11-09 20:40 Aggregate like AVG() with Money Data Type andre.toscano <andre.toscano@uol.com.br>
@ 2004-11-10 01:33 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2004-11-10 01:33 UTC (permalink / raw)
  To: andre.toscano <andre.toscano@uol.com.br>; +Cc: 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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-11-10 01:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-09 20:40 Aggregate like AVG() with Money Data Type andre.toscano <andre.toscano@uol.com.br>
2004-11-10 01:33 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox