Disabling scalar functions in a DSN.

From: Daniel Díaz <ddiaz(at)denodo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Disabling scalar functions in a DSN.
Date: 2014-05-21 08:03:19
Message-ID: 537C5DC7.6020908@denodo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message David Joffe 2014-05-21 20:26:01 Recent ODBC drivers possibly broken on XP - missing msvcrt dll
Previous Message Michael Paquier 2014-05-21 05:53:09 Re: Running regression tests on Windows