Re: Column types via ODBC interface - Mailing list pgsql-general

From Tom Lane
Subject Re: Column types via ODBC interface
Date
Msg-id 15986.960475564@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column types via ODBC interface  (Matt Goodall <mgg@isotek.co.uk>)
List pgsql-general
Matt Goodall <mgg@isotek.co.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [SQL] oracle rownum equivalent?
Next
From: Terence Gannon
Date:
Subject: Procedure Size Limitation