On Fri, 16 Aug 2019, Charles Clavadetscher wrote:
> That would be a range with an empty upper bound. Let's say that the rate
> is valid since 2019-08-14 then the range would look like
> [2019-08-14,)
> A query to find the current rate would look like:
>
> SELECT rate
> FROM labor_rate_mult
> WHERE validity @> CURRENT_DATE;
>
> Here you can find documentation on the range types (cool stuff I believe):
> https://www.postgresql.org/docs/11/rangetypes.html
Charles,
Interesting. Certainly worth considering the next time an application needs
a range of dates.
Regards,
Rich