Re: NUMERIC type makes trouble in MS Access

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: Whole Thread | Raw Message | 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

In response to

Browse pgsql-odbc by date

  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