News for hackers. Stuff that matters.

A comment on Common mistakes in PostgreSQL. Parent comment

Re:Common mistakes in PostgreSQL by gigatexal on Saturday May 04, 2019 @02:12AM (#19824758)
That makes sense actually. But stored procedures could do that too?
[ Parent | on HN ]
Re:Common mistakes in PostgreSQL by radiowave on Saturday May 04, 2019 @05:22AM (#19825368)
Yes. I tend to treat procedural code as a last resort, because pure declarative SQL is so much easier to troubleshoot.
[ Parent | on HN ]
Re:Common mistakes in PostgreSQL by gigatexal on Saturday May 04, 2019 @01:57PM (#19828043)
I guess I use stored procedures differently. I rely on SQL queries not for loops if I can help it. Sometimes it can’t be avoided if you’re doing updates in chunks for example.
[ Parent | on HN ]