I promised not to reveal this until first drafts were all submitted, but I’m enthusiastic to say that a PostGIS Cookbook is in the works that I’m coauthoring. Paolo Corti has the lion share of chapters, I am writing 4, Bborie Park has written a couple, as well as a nice chapter by Tom Kraft.
Do stay tuned… and expect that this will be a nice complement to the excellent writing on PostGIS already in print.