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?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: How to setup default value "0000-00-00" for "date"  (Christian Kratzer <ck-lists@cksoft.de>)
Re: How to setup default value "0000-00-00" for "date"  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: mihai11@mailcity.com (Razvan)
Дата:
Сообщение: Re: Postgres and JBOSS
Следующее
От: "Robert Ngo"
Дата:
Сообщение: need help with copy function