How to setup default value "0000-00-00" for "date" type under PostgreSQL?
От | Emi Lu |
---|---|
Тема | How to setup default value "0000-00-00" for "date" type under PostgreSQL? |
Дата | |
Msg-id | 41236B6D.5000606@cs.concordia.ca обсуждение исходный текст |
Ответы |
Re: How to setup default value "0000-00-00" for "date" type under PostgreSQL?
Re: How to setup default value "0000-00-00" for "date" Re: How to setup default value "0000-00-00" for "date" |
Список | pgsql-general |
Hello all, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for them. However, it seems that PostgreSQL does not support it. Could someone helps me please? The example table: T1 (col1 varchar(7) not null, col2 varchar(4) not null, col3 date not null, col 4 varchar(3), primary key(col1, col2, col3) ) In my design model, "col3" has to be one of the primary key part. Since at the beginning of the data population, we do not know the value of "col3"; values for "col3" are input throught GUI. Therefore, when I use MySQL, the default values I gave is "0000-00-00". However, after I migrate to postgreSQL, I could not setup the default values as "0000-00-00" any more. Could somebody help me about it please? I really want to know how I can save '0000-00-00' as the default value for "date" and "timestamp" types. Thanks a lot! Emi Lu
В списке pgsql-general по дате отправления: