Re: Comparing dates in DDL - Mailing list pgsql-general

From Rich Shepard
Subject Re: Comparing dates in DDL
Date
Msg-id alpine.LNX.2.20.1901041418320.29312@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Comparing dates in DDL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Comparing dates in DDL  (Jeremy Finzel <finzelj@gmail.com>)
List pgsql-general
On Fri, 4 Jan 2019, David G. Johnston wrote:

> That would be the decision to make - does your toolkit support (or can be
> made to support) the type and are you willing to choose a sub-optimal
> database model because one or more applications happen to do things
> differently?
>
> IMO the daterange datatype is the best type you can choose for the model;
> now you have to figure out and decide where any tradeoffs are and if they
> are worth it given your specific circumstances.

David,

   Thanks for the insights.

Regards,

Rich


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Comparing dates in DDL
Next
From: Ken Tanzer
Date:
Subject: Immutable way to cast timestamp TEXT to DATE? (for index)