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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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