Postgres Pro
Downloads
Home   >   mailing lists

Re: The same prepared query yield "-1" the first six times and then "-1.0" - Mailing list pgsql-general

From Edoardo Panfili
Subject Re: The same prepared query yield "-1" the first six times and then "-1.0"
Date
Msg-id D22FEEC1-17CE-4093-A201-EF1D76687279@gmail.com
Whole thread Raw
In response to Re: The same prepared query yield "-1" the first six times and then "-1.0"  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: The same prepared query yield "-1" the first six times and then "-1.0"
List pgsql-general
Tree view


Il giorno 21 ago 2023, alle ore 17:50, David G. Johnston <david.g.johnston@gmail.com> ha scritto:


On Mon, Aug 21, 2023 at 8:28 AM Edoardo Panfili <edoardo.panfili@iisgubbio.edu.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

pgsql-general by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Next
From: Edoardo Panfili
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"