From: | Edoardo Panfili <edoardo(dot)panfili(at)iisgubbio(dot)edu(dot)it> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: The same prepared query yield "-1" the first six times and then "-1.0" |
Date: | 2023-08-21 17:17:59 |
Message-ID: | D22FEEC1-17CE-4093-A201-EF1D76687279@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Il giorno 21 ago 2023, alle ore 17:50, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> ha scritto:
>
>
> On Mon, Aug 21, 2023 at 8:28 AM Edoardo Panfili <edoardo(dot)panfili(at)iisgubbio(dot)edu(dot)it <mailto:edoardo(dot)panfili(at)iisgubbio(dot)edu(dot)it>> wrote:
>>
>> dim1 real DEFAULT '-1' NOT NULL
>>
>> System.out.print("p: "+rs.getString("dim1")+"\n”);
>>
>> Can I do something to avoid this problem?
>
> Use the type appropriate getter, not getString, to retrieve the value of the underlying real typed column.
I know, but in this occasion I need to use text value.
>
> Otherwise, I agree this seems like a bug, probably in the JDBC driver, though one pertains to style as opposed to semantics since both answers are technically correct.
I will try, thank you
Edoardo
From | Date | Subject | |
---|---|---|---|
Next Message | Edoardo Panfili | 2023-08-21 17:24:03 | Re: The same prepared query yield "-1" the first six times and then "-1.0" |
Previous Message | Edoardo Panfili | 2023-08-21 17:16:17 | Re: The same prepared query yield "-1" the first six times and then "-1.0" |