Just a Theory

By David E. Wheeler

Batch Updates with PL/pgSQL

The third in my series of articles about PL/pgSQL, “Batch Updates with PL/pgSQL” has been published on The O’Reilly Network. Actually it was published last week, but I’ve not been very attentive to my blog lately. Sorry about that. Anyway, it improves upon the code in the second article in the series, “Managing Many-to-Many Relationships with PL/pgSQL,” by modifying the updating functions to use PostgreSQL batch query syntax. This means that the number of database calls in a given call to a function are constant, no matter how many IDs are passed to it.

So check it out!

Looking for the comments? Try the old layout.

More about…