Re: NUMERIC type makes trouble in MS Access - Mailing list 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