Search Postgresql Archives

Comparing dates in DDL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Comparing dates in DDL
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Fri, 4 Jan 2019 08:53:19 -0800 (PST)
Reply-to: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

  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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Comparing dates in DDL
  - From: Andreas Kretschmer
- Re: Comparing dates in DDL
  - From: Igor Korot

Prev by Date: Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger
Next by Date: Showing table comments with psql
Previous by thread: (Again) Column Store on PostGreSQL
Next by thread: Re: Comparing dates in DDL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux