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.
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.
pgsql-novice by date
|Next:||From: Alfred Perlstein||Date: 2001-01-30 19:10:40|
|Subject: Re: Best WebInterface...?|
|Previous:||From: Francisco Reyes||Date: 2001-01-30 15:56:33|
|Subject: Re: When replication?|