Re: ERROR: column "total_cost" is of type numeric but expression

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: ERROR: column "total_cost" is of type numeric but expression
Дата
Msg-id 420C98F5.1000802@logi-track.com
обсуждение исходный текст
Ответ на Re: ERROR: column "total_cost" is of type numeric but expression is of type character varying  (Antony Paul <antonypaul24@gmail.com>)
Ответы Re: ERROR: column "total_cost" is of type numeric but expression  (Antony Paul <antonypaul24@gmail.com>)
Список pgsql-jdbc
Hi, Antony,

Antony Paul schrieb:
> Updating application is going to be a lot of work. If it breaks
> existing applications why it is implemented. I dont think type
> checking is a big thing. What is its use ?.

I'm not 100% shure, as I'm no jdbc developer, but I think the 8.0 driver
consequently uses server-side prepared statements from V3 protocol, for
speed benefits, and thus needs all typing information. (I do not know
whether it is possible to send untyped parameters via this approach.)

Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com

Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: PLJava and Database Meta Data
Следующее
От: Antony Paul
Дата:
Сообщение: Re: ERROR: column "total_cost" is of type numeric but expression