On 1/4/19 10:12 AM, Igor Korot wrote:
Hi, Rich,
On Fri, Jan 4, 2019 at 10:53 AM Rich Shepard <rshep...@appl-ecosys.com> wrote:
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.
start_date.day() + 1?
Thank you.
TIA,
Rich
Is the end_date always knowable at record insert?
CHECK(end_date is null or start_date <= end_date)
