From: milimeter@163.com <milimeter@163.com>
To: pgsql-general@postgresql.org
Subject: jdbc problem
Date: Thu, 24 Apr 2003 09:38:58 +0800
Message-ID: <200304240938.58666."milimeter@163.com"> (raw)
Hi, all
I have a table: CREATE TABLE person (age char(4))
After executing "select age from person" with jdbc, I extract the value
with:
getInt("age")
Now is the problem, the same code can succeed on oracle, but on
postgresql, because of not triming space automaticlly, it cause an error.
So, I hope the newest jdbc driver for postgresql can automaticlly trim
space just like oracle. The same problem also exists when execute insert:
Provided "age" is an integer, then "insert into person values ('30')" can
be executed correctly, but "insert into person values ('')" can not. On
oracle, a default value will be added. So jdbc driver for postgresql should
also do it.
Yours,
mili
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: milimeter@163.com
Subject: Re: jdbc problem
In-Reply-To: <200304240938.58666."milimeter@163.com">
References: <200304240938.58666."milimeter@163.com">
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox