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