public inbox for [email protected]
help / color / mirror / Atom feedFrom: Karl Aschbacher <[email protected]>
To: [email protected]
Subject: Value changed from Integer to Double
Date: Mon, 11 Mar 2024 10:21:15 +0100
Message-ID: <CAADAuhBevN0+8fzUpg7j9R6H+dvis0E0nYg2MzPQooEkDyfx_g@mail.gmail.com> (raw)
Dear all,
we are facing a problem that is maybe related to the postgres-odbc driver.
We use Oracle Analytics Server via ODBC to talk to a postgres Database (V15)
It appears that integers with more than 10 digits get converted to doubles
when the statment is being sent to the database.
So for example: "where id = 32857641330" will be converted to "where did =
3285764133.0 "
So my question is - does the driver play any role when preparing the
statement?
(Like providing the PG Type ?)
In case it does, would anyone have a suggestion where to look for the
potential issue?
many thanks
best regards
Karl
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Value changed from Integer to Double
In-Reply-To: <CAADAuhBevN0+8fzUpg7j9R6H+dvis0E0nYg2MzPQooEkDyfx_g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox