Insert null in int column - Mailing list pgsql-jdbc

From venkata siva prasad
Subject Insert null in int column
Date
Msg-id 20101122175055.39596.qmail@f5mail-236-221.rediffmail.com
Whole thread Raw
Responses Re: Insert null in int column  (Maciek Sakrejda <msakrejda@truviso.com>)
Re: Insert null in int column  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc
Hi,

I have created the table as below.

create table test(id numeric(4),name character varying(8));

I need to insert null as below.

insert into test values(null,'aaa');

But  I am getting error as "Integer expecting..."


Can you please help me on this.

Regards,
Prasad

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: getTables() doesn't handle umlauts correctly
Next
From: Maciek Sakrejda
Date:
Subject: Re: Insert null in int column