News for hackers. Stuff that matters.

A comment on Soft deletion probably isn't worth it. Parent comment

Re:Soft deletion probably isn't worth it by sarchertech on Tuesday July 19, 2022 @03:54PM (#32157068)
I haven’t had any problems with this at all and I’ve been using joins in my views for years.

Are you using CTEs in your views?

[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by bavell on Tuesday July 19, 2022 @05:56PM (#32158494)
Postgres docs on CTEs: https://www.postgresql.org/docs/current/queries-with.html
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by tomnipotent on Tuesday July 19, 2022 @05:53PM (#32158470)
Postgres 12 fixed the CTE issue.
[ Parent | on HN ]