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

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