Re: Column types via ODBC interface

Tom Lane wrote:
>
> 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.

Great - I'll upgrade to v 7.x then.

> The SQL type returned for "bool" appears to be a user-settable option.

Sorry if I've missed something obvious in the docs but is that a
postgres setting or an odbc driver manager setting?

> 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

Fair enough - I should have explained my reasoning here.

Here's an bit from table 3-1.Postgres Data Types in the 6.5.3
documentation:

Postgres Type SQL92 or SQL3 Type
~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~
...
float4/8 float(p)
float8 real, double precision
...

I was expecing that to mean that float4/8 would map to an ODBC SQL_FLOAT
and float8 would map to either SQL_REAL or SQL_DOUBLE.

Cheers, Matt.

--
Matt Goodall | Isotek Electronics Ltd
email: mgg(at)isotek(dot)co(dot)uk | Claro House, Servia Road
Tel: +44 113 2343202 | Leeds, LS7 1NL
Fax: +44 113 2342918 | England