Re: Variable constants ?

[Rich Shepard]

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