SUM PROBLEM...

From: Sonia Sanchez Diaz <sonny(at)piaget(dot)dgsca(dot)unam(dot)mx>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: SUM PROBLEM...
Date: 2002-05-09 17:48:16
Message-ID: Pine.SGI.4.10.10205091043130.215963-100000@piaget.dgsca.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marcelo Henrique da Silva 2002-05-09 17:59:50 PAM Authentication
Previous Message David Stanaway 2002-05-09 16:25:07 Re: SUM PROBLEM...