Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.

Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.

If you are facing above mentioned behavior i.e. while pulling the data from the Postgres data source through Stored Procedure inside Spotfire Analyst, the columns having numeric data type are converted to Integer data type, then follow the resolution section. To stop this numeric data type conversion, follow the below steps:

1) For Spotfire 10.0 and older version, open Spotfire Analyst >> Tools Menu >> Information Designer.
    For Spotfire 10.0 and above, open Spotfire Analyst >> Data Menu >> Information Designer.

2) Now, open the stored procedure and inside result columns section, uncheck the option-> "Include all result columns"

3) Add the output/resultant columns one by one as per your requirement. https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details