Re: Insert null in int column

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?>
>