I think that use of CTEs (including recursive CTEs) in triggers can be useful (I have sometimes used it); like you, I have just found that it doesn't work if it isn't nested. I think this is an acceptable restriction for now.
I think that use of CTEs (including recursive CTEs) in triggers can be useful (I have sometimes used it); like you, I have just found that it doesn't work if it isn't nested. I think this is an acceptable restriction for now.