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
