Re: Variable constants ?

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Variable constants ?
Date: 2019-08-16 12:50:08
Message-ID: alpine.LNX.2.20.1908160549020.11183@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 16 Aug 2019, Charles Clavadetscher wrote:

> Another way to keep a history is using a daterange instead of two columns for
> start and end date. Something like
>
> create table labor_rate_mult (
> rate real primary_key,
> validity daterange not null
> )

Charles,

Just out of curiosity, what is the range for a rate that is still current?
Does it change every day?

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2019-08-16 13:25:30 Re: Variable constants ?
Previous Message Litwin, Efrem 2019-08-16 12:28:39 ODBC Driver Version for PostgreSQL 11.3