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

Re: null to zero?

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: cmarkiew(at)commnav(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org, chris(dot)markiewicz(at)commnav(dot)com
Subject: Re: null to zero?
Date: 2001-04-11 00:21:08
Message-ID: 3AD3A374.3E44FC0B@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
That is correct.  This behavior is supposed to go away in 7.1

chris markiewicz wrote:
> 
> 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...
> 


-- 
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio.  http://www.targabot.com

In response to

pgsql-jdbc by date

Next:From: Tony GrantDate: 2001-04-11 09:35:42
Subject: Re: JDBC and Perl compiling problems w/ postgresql-7.1rc4
Previous:From: Homayoun Yousefi'zadehDate: 2001-04-10 23:38:28
Subject: Re: JDBC and Perl compiling problems w/ postgresql-7.1rc4

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