On 09/03/2017 03:34 PM, Tom Lane wrote: > Joe Conway <m...@joeconway.com> writes: >> Notice that tsr is not empty at all on the first loop, but on the second >> loop it is empty every second time the trigger fires. > > I think the issue is that now() isn't changing within the transaction, > so when you construct "tstzrange(lower(OLD.tr), now(), '[)')" using an > old row whose "lower(OLD.tr)" is already "now()", you get an empty range. > Probably using '[]' bounds would avoid the oddness.
Hmmm, good point. Sorry for the noise. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
