Re: Variable constants ? - Mailing list pgsql-general

From Rich Shepard
Subject Re: Variable constants ?
Date
Msg-id alpine.LNX.2.20.1908160549020.11183@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Variable constants ?  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Responses Re: Variable constants ?  (Charles Clavadetscher <clavadetscher@swisspug.org>)
List 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



pgsql-general by date:

Previous
From: "Litwin, Efrem"
Date:
Subject: ODBC Driver Version for PostgreSQL 11.3
Next
From: Charles Clavadetscher
Date:
Subject: Re: Variable constants ?