Thread: any signed decimal data type?

any signed decimal data type?

From
joseph speigle
Date:
hello,

I have lines in a csv like these:

07/09/2002,'ORDER POSTING',-5,'TMT',0.463,10.8,0
01/06/2003,'ORDER POSTING',75.76,'C',-2.4524,37.4,15.96
--'Date','Description','Amount','Symbol','Quantity','Price','Commission'

The quantity column is negative for a withdrawal (sell stocks), positive otherwise.  I have no other way with this data
setto see if withdrawal/deposit.  any hope of a signed decimal datatype for this?  There is too much precision for
"money"datatype.  I am using pgsql 

muchas gracias,

joe
--
joe speigle
www.sirfsup.com

Re: any signed decimal data type?

From
Tom Lane
Date:
joseph speigle <joe.speigle@jklh.us> writes:
> any hope of a signed decimal datatype for this?

Use NUMERIC (a/k/a DECIMAL).

            regards, tom lane

Re: any signed decimal data type?

From
joe speigle
Date:
oh, that was just too easy.  just numeric.  glad I only wasted my own time on this one :(