Re: The same prepared query yield "-1" the first six times and then "-1.0"
От
David G. Johnston
Тема
Re: The same prepared query yield "-1" the first six times and then "-1.0"
Дата
Msg-id
CAKFQuwZzVWzxpcbeJsS2ZSBCi1j310B+N=5v-9roObQaq2dVEQ@mail.gmail.com
Ответ на
The same prepared query yield "-1" the first six times and then "-1.0" (Edoardo Panfili)
Список
Дерево обсуждения
The same prepared query yield "-1" the first six times and then "-1.0" Edoardo Panfili <edoardo.panfili@iisgubbio.edu.it>
Re: The same prepared query yield "-1" the first six times and then "-1.0" "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Edoardo Panfili <edoardopa@gmail.com>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Dave Cramer <davecramer@postgres.rocks>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Edoardo Panfili <edoardopa@gmail.com>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Dave Cramer <davecramer@postgres.rocks>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Adrian Klaver <adrian.klaver@aklaver.com>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Edoardo Panfili <edoardo.panfili@iisgubbio.edu.it>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Dave Cramer <davecramer@postgres.rocks>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Ron <ronljohnsonjr@gmail.com>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Dave Cramer <davecramer@postgres.rocks>
Re: The same prepared query yield "-1" the first six times and then "-1.0" "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: The same prepared query yield "-1" the first six times and then "-1.0" "David G. Johnston" <david.g.johnston@gmail.com>
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>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Pavel Stehule <pavel.stehule@gmail.com>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Dave Cramer <davecramer@postgres.rocks>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Edoardo Panfili <edoardo.panfili@iisgubbio.edu.it>
Re: The same prepared query yield "-1" the first six times and then "-1.0" Rob Sargent <robjsargent@gmail.com>
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 по дате отправления
От: Adrian Klaver
Дата:
От: Adrian Klaver
Дата:
