I’ve been looking at use of undocumented Postgres functions and I found four in the ODBC driver:
The POWER function maps to pow. It should be power. pow works but is undocumented.
The CONCAT function maps to textcat. It should be concat. textcat works is undocumented.
The LEFT and RIGHT functions are set to map to ltrunc and rtrunc. These functions don’t exist – it should just be left and right. The driver also doesn’t report that LEFT and RIGHT are supported.
Thanks,
Dan