News for hackers. Stuff that matters.

A comment on Mastering PostgreSQL in Application Development.

Re:Mastering PostgreSQL in Application Development by djklanac on Monday November 06, 2017 @09:36AM (#15635695)
I didn't see any reference to PL/pgSQL in the table of contents. Does your book go into common strategies with stored procedures (e.g. When to LOOP to build a temp table vs. using table joins)?
[ Parent | on HN ]
Re:Mastering PostgreSQL in Application Development by tapoueh on Monday November 06, 2017 @09:39AM (#15635715)
No, I don't address that point in this book.

It gives you plenty SQL techniques to avoid ever having to LOOP in a PL/pgSQL function, and show how to use PL/SQL rather than PL/pgSQL each time it is possible, though.

[ Parent | on HN ]
Re:Mastering PostgreSQL in Application Development by djklanac on Monday November 06, 2017 @09:48AM (#15635792)
Sweet. I'll give your book a read then. Gaining a more solid SQL foundation to avoid LOOP in the first place is what I need.
[ Parent | on HN ]