'" <[EMAIL PROTECTED]>,
!> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: [SQL] Numeric and money
Man, where is limit between spam and question to mailing list?!
Karel
[ mail lists trimmed to something a tad more reasonable ]
Michael Davis <[EMAIL PROTECTED]> writes:
> From within Access, I can't update any table with a numeric data type
> because of the "select * from tst where amount = 1.1;" failure.
Yeah. The problem here is the conflict between interpret
Hi Michael,
>create table tst (id int, amount numeric(9,2));
>insert into tst values (1, 1.10);
>insert into tst values (2, 1.00);
>insert into tst values (2, 2.00);
>select * from tst where amount = 1; -- works
>select * from tst where amount = 1.1
Hello Everyone,
I am in the process of migrating my Access97 application to PostgreSQL. So
far everything looks great with one exception. I converted my currency
fields in Access to numeric(9,2) as recommended in the PostgreSQL
documentation. Many things to don't play well with the numeric
