On 2020-Jan-23, Bruce Momjian wrote: > Yes, good point. I think my one concern is that someone might specify > both keys in the JSON, which would be very odd.
Just make that a reason to raise an error. I think it's even possible to specify that as a JSON Schema constraint, using a "oneOf" predicate. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services