That makes sense actually. But stored procedures could do that too? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		gigatexal on May 4, 2019 \| parent \| context \| favorite \| on: Common mistakes in PostgreSQL That makes sense actually. But stored procedures could do that too?

radiowave on May 4, 2019 [–]

Yes. I tend to treat procedural code as a last resort, because pure declarative SQL is so much easier to troubleshoot.

gigatexal on May 4, 2019 | [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact