24 Oct
2006
24 Oct
'06
4:05 a.m.
Hi: In a PostgreSQL DB I have a Numeric data type with a precision of two decimal places. If I have 1.33 in as the result from my query, it's everything is good. However, if I have 1.30 it reduces the precision to one decimal place and I get 1.3. Not so good when dealing with currency ( I don't want to use the money data dype ). Any ideas on how I can get my ZSQL method to keep two decimal places? Thanks, Jason. -- ........................................ .... Jason C. Leach .... PGP Key: 0x62DDDF75 .... Keyserver: gpg.mit.edu