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
