I've defined a field as numeric(5,2) - I'm using it for monetary amounts.
After inserting values such as 8.50 or 29.00 into the database, a select
from within psql gives the correct amount, i.e.
-------
23.65
21.25
8.50
31.95
25.15
20.75
18.75
32.60
52.10
29.00
However, windows based queries (through pgAdmin) drop trailing zeros, such
as 8.5 or 29
Can someone suggest how to prevent this from happening? Obviously I don't
want to display prices without the decimals. Is it something to do with the
odbc driver (Insight 6.5 & Postgresql 6.5)?
Any help is greatly appreciated.
Marc