[cultofmetatron]

seriously.. I'm building out some functionality using plpgsql and have used it. This is going to be haunting my dreams

[wesd]

there is possible performance hit [1]. Also, it could mean that the data granularity has not been modeled well if there are duplicate rows.

https://sqlperformance.com/2017/01/t-sql-queries/surprises-a...