Re: How can I insert NULL into column with the type of timestamp?

bookman bookman escribió:

> Then error occured:
>     error:invalid input syntax for type timestamp:""
>     context:copy T_Admin ,line 2,column regDate:""
> It seemed that the column REGDATE cannot accept a NULL.I tested it use:
>    insert into T_Admin(name,key,regDate,isLock,realName)
>    values('aaa','aaa','','1','aaa');
> The same error occured.
>
>   So it means that the column with type timestamp cannot accept a NULL
> .Is there any way I can tansfer this table into postgre?How can i deal
> with NULL in this case?

No, it doesn't mean that.  It means that you are trying to insert an
empty string.  Try this:

    insert into T_Admin(name,key,regDate,isLock,realName)
    values('aaa','aaa',NULL,'1','aaa');

Similarly, the NULL timestamp column in the file you give to COPY should
not contain empty quotes.

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"Crear es tan difícil como ser libre" (Elsa Triolet)