inserting data in time field

[priyan]

hai everyone,
I am having a doubt in inserting data in time field.
I am having a table in which in column in timestamp without time zone datatype. I want to insert a row into the table but that time field has no value if I insert omitting that column error occurs...
for eg.

CREATE TABLE blah
(
  uuid integer NOT NULL DEFAULT nextval('universal_sq'::regclass),
  "time" timestamp without time zone
) 
WITHOUT OIDS;
 

insert query:

insert into blah (uuid,time)values (5,'')
 

I am getting an error like this:

ERROR: invalid input syntax for type timestamp: ""
SQL state: 22007
 

Please help me i should have that column name in the list but should not have an value for that column.please tell me is there any possible way for this. please help me as soon as possible.....

[michaelb]

... ... ...

CREATE TABLE blah
(
  uuid integer NOT NULL DEFAULT nextval('universal_sq'::regclass),
  "time" timestamp without time zone
) 
WITHOUT OIDS;
 

insert query:

insert into blah (uuid,time)values (5,'')
 

I am getting an error like this:

ERROR: invalid input syntax for type timestamp: ""
SQL state: 22007
 

... ... ...

Either one of these two statements should work for you:

insert into blah (uuid,time) values (5, NULL);
insert into blah (uuid) values (5);
 

Did you see the manual page for INSERT command?

You probably realize that outside of this example there's no need to provide a value for the SERIAL field uuid.

[priyan]

Either one of these two statements should work for you:

insert into blah (uuid,time) values (5, NULL);
insert into blah (uuid) values (5);
 

Did you see the manual page for INSERT command?

You probably realize that outside of this example there's no need to provide a value for the SERIAL field uuid.

thank you for helping me

[gauravgmbhr]

thank you for helping me

U can also use Values (5,Default) instead of values (5,NULL)

Both works


Regards Gaurav

[priyan]

U can also use Values (5,Default) instead of values (5,NULL)

Both works


Regards Gaurav

Thank you very much helping me..