Postgres Pro
Downloads
Home   >   mailing lists

SUM PROBLEM... - Mailing list pgsql-admin

From Sonia Sanchez Diaz
Subject SUM PROBLEM...
Date
Msg-id Pine.SGI.4.10.10205091043130.215963-100000@piaget.dgsca.unam.mx
Whole thread Raw
In response to Re: postgresql authentication  (Hal Lynch <hal@cc.usu.edu>)
Responses Re: SUM PROBLEM...  (David Stanaway <david@stanaway.net>)
List pgsql-admin
Tree view 
Hy!

I have one money type field and I need to plus it, but when I run the
query I get a negative answer!

But I don't have negative numbers into this field...???

What's up here??

The query is:

select sum(field) from table;

and the answer is:

field
--------
-$5,083,598.58

Regards!

Sonny

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: db recovery (FATAL 2)
Next
From: David Stanaway
Date:
Subject: Re: SUM PROBLEM...