Re: On exclusion constraints and validity dates

2024-08-26 Thread Paul Jungwirth
On 8/22/24 11:13, Justin Giacobbi wrote: I have an issue that on the surface seems orthogonal to existing functionality. I’m trying to dynamically update validity ranges as new s replace old s. In a nutshell the problem looks like this: psqlprompt=# select * from rangetest; id |  

Re: On exclusion constraints and validity dates

2024-08-25 Thread Adrian Klaver
On 8/22/24 11:13, Justin Giacobbi wrote: Hello, Currently I’m looking at working around this in the application or in a stored procedure/insert trigger that is essentially the same logic. Whichever seems easier to maintain. Advice on how to submit a feature request, or maybe a better worka

On exclusion constraints and validity dates

2024-08-24 Thread Justin Giacobbi
Hello, I have an issue that on the surface seems orthogonal to existing functionality. I'm trying to dynamically update validity ranges as new s replace old s. In a nutshell the problem looks like this: psqlprompt=# select * from rangetest; id | rangecol +-