Insert null in int column

From: "venkata siva prasad" <vsp_29(at)rediffmail(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Insert null in int column
Date: 2010-11-22 17:50:55
Message-ID: 20101122175055.39596.qmail@f5mail-236-221.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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&nbsp; I am getting error as "Integer expecting..."

Can you please help me on this.

Regards,
Prasad

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maciek Sakrejda 2010-11-22 17:52:37 Re: getTables() doesn't handle umlauts correctly
Previous Message Thomas Kellerer 2010-11-22 13:50:38 Re: getTables() doesn't handle umlauts correctly