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

From: Markus Schaber <schabios(at)logi-track(dot)com>
To: Antony Paul <antonypaul24(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ERROR: column "total_cost" is of type numeric but expression
Date: 2005-02-11 11:37:25
Message-ID: 420C98F5.1000802@logi-track.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)logi-track(dot)com | www.logi-track.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Antony Paul 2005-02-11 11:47:46 Re: ERROR: column "total_cost" is of type numeric but expression
Previous Message Markus Schaber 2005-02-11 11:34:05 Re: PLJava and Database Meta Data