Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: column "total_cost" is of type numeric but expression - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: ERROR: column "total_cost" is of type numeric but expression
Date
Msg-id 420C98F5.1000802@logi-track.com
Whole thread Raw
In response to Re: ERROR: column "total_cost" is of type numeric but expression is of type character varying  (Antony Paul <antonypaul24@gmail.com>)
Responses Re: ERROR: column "total_cost" is of type numeric but expression
List pgsql-jdbc
Tree view 
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
Attachment

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: PLJava and Database Meta Data
Next
From: Antony Paul
Date:
Subject: Re: ERROR: column "total_cost" is of type numeric but expression