It's not hugely complex although definitely more than the first example. I guess it depends whether it's offset by the benefits... https://dbfiddle.uk/?rdbms=

It's not hugely complex although definitely more than the first example. I guess it depends whether it's offset by the benefits... https://dbfiddle.uk/?rdbms=postgres_11&fiddle=50e6a963cd1db0ae4108e78a3fc57f10 https://dbfiddle.uk/?rdbms=postgres_11&fiddle=50e6a963cd1db0... (YMMV, obvs.)