Matt Goodall <mgg(at)isotek(dot)co(dot)uk> writes:
> f10 decimal(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9
> f11 numeric(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9
The 6.5 ODBC driver doesn't know about type numeric, so it returns its
default assumption, which is varchar as above. The 7.0 version knows
about numeric, however.
The SQL type returned for "bool" appears to be a user-settable option.
The choices made for floating types look reasonably plausible.
If you think they're wrong, you'll need to argue why, not just
assert that you think they are. It's easy enough to change the
ODBC driver's SQL type <=> Postgres type mapping if there's a
better definition than what we're using...
regards, tom lane