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 set to 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

joseph speigle <joe.speigle (AT) jklh (DOT) us> writes:
Use NUMERIC (a/k/a DECIMAL).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org