As an aside from my last question about my LYDB effort:
I would like to find a book or other resource about SQL server-side programming (stored procedures etc) best practices in general and for Postgres in particular.
Seems like a thing that should exist. I can find a variety of blog posts, mostly about Oracle and MS SQL Server, but nothing that appears particularly canonical or “classic”.
Is there such a resource?