Matt Goodall <mgg(at)isotek(dot)co(dot)uk> writes:
> Sorry if I've missed something obvious in the docs but is that a
> postgres setting or an odbc driver manager setting?
odbc side.
> 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.
The code in odbc's pgtypes.c maps float4 to SQL_REAL and float8 to
SQL_FLOAT. Perhaps that's backward, or perhaps not; do the ODBC specs
say anything about the expected precision associated with SQL_REAL
or SQL_FLOAT?
regards, tom lane