Обсуждение: ODBC Scalar Function RIGHT() maps to rtrunc()?

Поиск
Список
Период
Сортировка

ODBC Scalar Function RIGHT() maps to rtrunc()?

От
Raiford@labware.com
Дата:
When using the RIGHT() ODBC scalar function, I'm getting an error:

ERROR: function rtrunc(integer, integer) does not exist;

I know the odbc.sql file contained in the source used to include rtrunc(), but it no longer does.  Also it seems it is not used anyway (are we supposed to create these functions on each database we want to use the ODBC driver?).

Am I missing something?

PostgreSQL version:
PostgreSQL 9.3.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit

ODBC driver version:
9.01.01.00

btw, I know that my ODBC driver version is a bit out of date, but looking at the source it seems that this RIGHT->rtrunc mapping is still in place.

Jon

Re: ODBC Scalar Function RIGHT() maps to rtrunc()?

От
Raiford@labware.com
Дата:
Grrr..

Please ignore.  I can see my mistake.  I had tried (and apparently failed) to convert an integer field to a varchar for the first argument.

Jon

>>>>>>>

When using the RIGHT() ODBC scalar function, I'm getting an error:

ERROR: function rtrunc(integer, integer) does not exist;

I know the odbc.sql file contained in the source used to include rtrunc(), but it no longer does.  Also it seems it is not used anyway (are we supposed to create these functions on each database we want to use the ODBC driver?).

Am I missing something?

PostgreSQL version:
PostgreSQL 9.3.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit

ODBC driver version:
9.01.01.00

btw, I know that my ODBC driver version is a bit out of date, but looking at the source it seems that this RIGHT->rtrunc mapping is still in place.

Jon