Matching types

From: Vicente Alabau Gonzalvo <vicente(dot)alabau-gonzalvo(at)cgey(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Matching types
Date: 2003-02-03 08:01:03
Message-ID: 3E3E21BF.4000906@capgemini.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Does anybody know how to get BigDecimal from numeric and how to put
BigDecimal to numeric using jdbc?
The first thing seems to work automaticaly.
BigDecimal seems to be converted into double precision when put in a
query. Then it can't be compared with a numeric value.

ERROR: Unable to identify an operator '=' for types 'numeric' and
'double precision'
You will have to retype this query using an explicit cast

Can it be done without doing an explicit cast?

Thanks in advance.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kuldip 2003-02-03 08:57:50 problem with currency symbol in rs.getString
Previous Message etsuko shimabukuro 2003-02-03 07:49:32 Re: How do I capture the message from user defined function