Postgres Pro
Downloads
Home   >   mailing lists

Re: How to detect float format by passing SQL_CHAR to float column ? - Mailing list pgsql-odbc

From Tom Lane
Subject Re: How to detect float format by passing SQL_CHAR to float column ?
Date
Msg-id 16523.1137685193@sss.pgh.pa.us
Whole thread Raw
In response to How to detect float format by passing SQL_CHAR to float column ?  ("lothar.behrens@lollisoft.de" <lothar.behrens@lollisoft.de>)
List pgsql-odbc
Tree view 
"lothar.behrens@lollisoft.de" <lothar.behrens@lollisoft.de> writes:
> as the documentation of postgresql, there is a floating point format
> like 10.1234 but I do not see
> 10,1234. Is that ever like the documentation ?

No, we deliberately do not support locale-dependent numeric styles.
At least not in simple data entry --- IIRC, you can convert such
strings with to_char()/to_number().

            regards, tom lane

pgsql-odbc by date:

Previous
From: "lothar.behrens@lollisoft.de"
Date:
Subject: How to detect float format by passing SQL_CHAR to float column ?
Next
From: Shachar Shemesh
Date:
Subject: Re: Parameters.Refresh error.