Re: Column types via ODBC interface
От | Matt Goodall |
---|---|
Тема | Re: Column types via ODBC interface |
Дата | |
Msg-id | 393F6A40.FFD7706F@isotek.co.uk обсуждение исходный текст |
Ответ на | Column types via ODBC interface (Matt Goodall <mgg@isotek.co.uk>) |
Ответы |
Re: Column types via ODBC interface
|
Список | pgsql-general |
Tom Lane wrote: > > Matt Goodall <mgg@isotek.co.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@isotek.co.uk | Claro House, Servia Road Tel: +44 113 2343202 | Leeds, LS7 1NL Fax: +44 113 2342918 | England
В списке pgsql-general по дате отправления: