Postgres Pro
Downloads
Home   >   mailing lists

Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver - Mailing list pgsql-odbc

From Scott Goley
Subject Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Date
Msg-id 7F0D7846-95BA-4396-BDEC-FEC80D4C1ECC@getmailspring.com
Whole thread Raw
Responses Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Tree view
Hi,

Platform / Version info:

Postgres 11.4
psqlODBC_x64 v 11.01.0000

I'm a developer working with PowerQuery / ODBC and I'm running into the following issue.


I'm developing a custom connector which is utilizing this driver. I've attached the logs as requested when making a bug report. It looks like the SQL_TSI_DAY operator is being "interpreted" by the driver as a column reference rather than making the necessary conversion to the correct datetimeadd "interval" .

I'm attaching the connector file - ODBCPostgresDirect simply because it contains all the flags that I'm setting for SQLCapabilities, ODBC function overrides etc.

Any input on this would be helpful.

Best,
Scott

Sent from Mailspring
Attachment

pgsql-odbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Postgresql Document Required
Next
From: Xuesong Gao
Date:
Subject: RE: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255