News for hackers. Stuff that matters.
Re:Medium-hard SQL interview questions by cultofmetatron on Saturday May 02, 2020 @04:24PM (#23054630)
seriously.. I'm building out some functionality using plpgsql and have used it. This is going to be haunting my dreams
Re:Medium-hard SQL interview questions by wesd on Saturday May 02, 2020 @04:48PM (#23054785)
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...