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

Re: Insert null in int column

From: dmp <danap(at)ttc-cmc(dot)net>
To: venkata siva prasad <vsp_29(at)rediffmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Insert null in int column
Date: 2010-11-22 19:56:40
Message-ID: 4CEACAF8.5040907@ttc-cmc.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello Prasad,

Attached class that should demostrate the insert you desire. The
insertion for Postgresql via SQL can be done through two different
methods.

Singular Example:
INSERT/REPLACE INTO "bigInt_types" ("data_type_id", "bigint_type") VALUES (NULL, 
'5');
INSERT/REPLACE INTO "bigInt_types" ("data_type_id", "bigint_type") VALUES (NULL, 
'-65');

Plural Example:
INSERT/REPLACE INTO "bigInt_types" ("data_type_id", "bigint_type") VALUES (NULL, 
'5'),(NULL, '-65');

danap.

venkata siva prasad wrote:
> 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
>
> <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline(dot)htm(at)Middle?>
>


Attachment: PostgreSQL_JDBC2.java
Description: text/plain (5.9 KB)

In response to

Responses

pgsql-jdbc by date

Next:From: dmpDate: 2010-11-22 20:04:25
Subject: Re: Insert null in int column
Previous:From: Thomas KellererDate: 2010-11-22 18:59:26
Subject: Re: getTables() doesn't handle umlauts correctly

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