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

Поиск

Список

Период

Сортировка

От	Edoardo Panfili
Тема	Re: The same prepared query yield "-1" the first six times and then "-1.0"
Дата	21 августа 2023 г. 17:17:59
Msg-id	D22FEEC1-17CE-4093-A201-EF1D76687279@gmail.com обсуждение
Ответ на	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"
Список	pgsql-general

Дерево обсуждения

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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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