Disabling scalar functions in a DSN. - Mailing list pgsql-odbc

From Daniel Díaz
Subject Disabling scalar functions in a DSN.
Date
Msg-id 537C5DC7.6020908@denodo.com
Whole thread Raw
Responses Re: Disabling scalar functions in a DSN.  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List pgsql-odbc
Hi,

I have a few doubts about ODBC scalar function support.

After having installed the driver and created a DSN, is there some flag that can be set to disable support for scalar functions like {fn current_date()}, and in a way that clients can detect by calling SQLGetInfo?

Alternatively, is there a way to configure a DSN so that scalar functions are sent to the database "as themselves", for example {fn current_date()} =====> current_date() ?

Looking in the driver source code, I see a file odbc.sql, that contains Postgres function definitions. What is the purpose of this file? To be able to invoke scalar functions directly without needing the {fn ...} syntax ?

Thanks in advance,
Daniel

pgsql-odbc by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Running regression tests on Windows
Next
From: "John C. Frickson"
Date:
Subject: Query buffer allocate error in copy_statement_with_parameters