Postgres Pro
Downloads
Home   >   mailing lists

data set combination of integer and decimal/numeric returns wrong result type - Mailing list pgsql-jdbc

From the6campbells
Subject data set combination of integer and decimal/numeric returns wrong result type
Date
Msg-id CAFEjsq4oeM25e=7Tn1X2Fe2RLMsDBqp7h9iU6Fu9nxd+ibXEng@mail.gmail.com
Whole thread Raw
Responses Re: data set combination of integer and decimal/numeric returns wrong result type  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-jdbc
Tree view
integer
union 
decimal/numeric (7,2)

select tint.cint from tint union select tdec.cdec from tdec 

no precision is returned as expected etc 
display size is odd



ColumnIndexgetColumnNamegetColumnTypeNamegetPrecisiongetScaleisNullablegetTableNamegetSchemaNamegetCatalogNamegetColumnClassNamegetColumnDisplaySizegetColumnLabelgetColumnTypeisAutoIncrementisCaseSensitiveisCurrencyisDefinitelyWritable isReadOnlyisSearchableisSignedisWritable
1cintnumeric002   java.math.BigDecimal131089cint2falsefalsefalsefalsefalsetruetruetrue

pgsql-jdbc by date:

Previous
From: the6campbells
Date:
Subject: Re: data type of projected item in a union not correct
Next
From: Kris Jurka
Date:
Subject: Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?