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 David G. Johnston
Subject Re: The same prepared query yield "-1" the first six times and then "-1.0"
Date
Msg-id CAKFQuwZzVWzxpcbeJsS2ZSBCi1j310B+N=5v-9roObQaq2dVEQ@mail.gmail.com
Whole thread Raw
In response to The same prepared query yield "-1" the first six times and then "-1.0"  (Edoardo Panfili <edoardo.panfili@iisgubbio.edu.it>)
Responses Re: The same prepared query yield "-1" the first six times and then "-1.0"  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: The same prepared query yield "-1" the first six times and then "-1.0"  (Edoardo Panfili <edoardo.panfili@iisgubbio.edu.it>)
List pgsql-general
Tree view

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.

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.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Next
From: Adrian Klaver
Date:
Subject: Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?