Postgres Pro
Downloads
Home   >   mailing lists

Comparing dates in DDL - Mailing list pgsql-general

From Rich Shepard
Subject Comparing dates in DDL
Date
Msg-id alpine.LNX.2.20.1901040851090.29312@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Comparing dates in DDL  (Igor Korot <ikorot01@gmail.com>)
Re: Comparing dates in DDL  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view 
   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?
   2. If so, please suggest a value for it.

TIA,

Rich

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Potentially undocumented behaviour change in Postgres 11concerning OLD record in an after insert trigger
Next
From: Pavel Stehule
Date:
Subject: Re: Showing table comments with psql