From: | "Tobias Wendorff" <tobias(dot)wendorff(at)tu-dortmund(dot)de> |
---|---|
To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
Cc: | pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: NUMERIC type makes trouble in MS Access |
Date: | 2018-05-26 18:43:57 |
Message-ID: | 8492731c6ad493448ba8ed226888cfca.squirrel@webmail.tu-dortmund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Hiroshi,
thanks for your reply!
Am Sa, 26.05.2018, 14:23 schrieb Inoue, Hiroshi:
>> commercial ODBC driver:
>
> What is the commercial ODBC driver?
Devart ODBC Driver for PostgreSQL
> The column v is numeric item without precision.
> Are the following insertions possible using the commercial DBMS?
>
>> INSERT INTO demo VALUES (1.0123456789);
>> INSERT INTO demo VALUES (1.01234567890123456789);
>> INSERT INTO demo VALUES (12345.012345678901234567890123456789);
I don't insert things, it's a read only database. The problem is
about getting the data into Access. The insertions just were an
example for testing, which values or types actually make an issue ;)
Could you perhaps add a switchable function like "cast numeric to
float"?
Best regards,
Tobias
From | Date | Subject | |
---|---|---|---|
Next Message | Tobias Wendorff | 2018-05-27 02:58:10 | Re: NUMERIC type makes trouble in MS Access |
Previous Message | Inoue, Hiroshi | 2018-05-26 12:23:59 | Re: NUMERIC type makes trouble in MS Access |