Re: Comparing dates in DDL
| От | Andreas Kretschmer |
|---|---|
| Тема | Re: Comparing dates in DDL |
| Дата | |
| Msg-id | f0afb3bf-d582-8050-fb83-06b342e84b43@a-kretschmer.de обсуждение исходный текст |
| Ответ на | Comparing dates in DDL (Rich Shepard <rshepard@appl-ecosys.com>) |
| Ответы |
Re: Comparing dates in DDL
|
| Список | pgsql-general |
Am 04.01.19 um 17:53 schrieb Rich Shepard: > I have a projects table that includes these two columns: > > start_date date DEFAULT CURRENT_DATE, > end_date date > CONSTRAINT valid_start_date > CHECK (start_date <= end_date), > > 1. Do I need a DEFAULT value for the end_date? no, you can use NULL, for instance. You don't need an explicit value. But maybe you want to set the start_date to NOT NULL. > 2. If so, please suggest a value for it. other solution for such 2 fields: you can use DATERANGE, only one field. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
В списке pgsql-general по дате отправления: