Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver

Hi Scott,

Could you please try the test drivers 11.00.0200 on Windows at
https://winpg.jp/~inoue/psqlodbc/index.html
?

regards,
Hiroshi Inoue

On 2019/08/11 7:51, Scott Goley wrote:
> Hiroshi,
>
> Thank you for your response. I will definitely look into that.
>
> Is there any resource which specifies what functions and flags are
> supported via the current psqlODBC driver?  That would be extremely
> helpful to me if you were aware of one.
>
> Best,
> Scott G
>
>
>
> On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
> wrote:
>
> Hi Scott,
>
> Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is
> supported now.
> Could you please try test drivers which would support them?
>
> regards,
> Hiroshi Inoue
>
> On 2019/08/09 0:00, Scott Goley wrote:
>
>
> 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
>

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com