Skip site navigation (1) Skip section navigation (2)

RE: null to zero?

From: "chris markiewicz" <cmarkiew(at)commnav(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Cc: <chris(dot)markiewicz(at)commnav(dot)com>
Subject: RE: null to zero?
Date: 2001-04-06 14:59:37
Message-ID: 020601c0beaa$33ea1330$dbb846c6@cmarkiewicz (view raw or flat)
Thread:
Lists: pgsql-jdbc
hello.

it seems that a null value in an integer (int4) column gets converted to
zero at some point...is this accurate?  i look in the db and see null
(queried using IS NULL to make sure), but i call an rs.getObject(colName)
and get a java.lang.Integer with a value of zero...is this in jdbc or java?
an Integer can BE null, but it cannot have a value of null...

didn't see anything in the archives...

thanks
chris


In response to

Responses

pgsql-jdbc by date

Next:From: Sheer El-ShowkDate: 2001-04-06 19:24:00
Subject: Error codes in JDBC drivers
Previous:From: jlemckeDate: 2001-04-06 13:03:57
Subject: Re: Help for java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group