Postgres Pro
Downloads
Home   >   mailing lists

ODBC Scalar Function RIGHT() maps to rtrunc()? - Mailing list pgsql-odbc

From Raiford@labware.com
Subject ODBC Scalar Function RIGHT() maps to rtrunc()?
Date
Msg-id OFB24436DD.0938E257-ON85257DF7.0051C88C-85257DF7.0052526F@labware.com
Whole thread Raw
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: "Faith, Jeremy"
Date:
Subject: Re: [PATCH] SQLFreeStmt deletes params, but does not reset the stmt->prepared state.
Next
From: Raiford@labware.com
Date:
Subject: Re: ODBC Scalar Function RIGHT() maps to rtrunc()?