Message-ID: <gh-postgresql-interfaces-psqlodbc-82-c2544065520@github.com>
From: "JacoboSanchez (@JacoboSanchez)" <noreply+JacoboSanchez@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Sun, 15 Dec 2024 21:05:02 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #82: Is this expected a bind to BIGINT to be surrounded by quotes?
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-82@github.com>
References: <gh-postgresql-interfaces-psqlodbc-82@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: JacoboSanchez
X-GitHub-Comment-Id: 2544065520
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 82
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/82#issuecomment-2544065520
Content-Type: text/plain; charset=utf-8

It is automatically cast when using a plain SQL. In JDBC if you use the parameter in the prepared statement and set a String object then an error is thrown due to incompatible types.That JDBC failure was the reason to end up looking at this in ODBC.

The error In JDBC when assigning is the following (only using a parameter at the statement, not with explicit text literal):
```
operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts
```