Stored Procedure in postgresql, multiple queries w/ agreggates.

Question

I'm trying to write a store procedure that can take some input parameters (obviously), run multiple queries against those, taking the output from those and doing calculations, and from those calculations and the original queries, outputting a formatted text string like:

Number of Rows for max(Z) matching condition x and y of total rows matching x (x&y/x*100).

To explain the max(Z) bit, this will be the username field, it won't matter which actual entry is picked, because the where clause will filter the results by user id, is there a saner way to do this?

Answer 1

For starters break the code up into multiple procedures. Don't create one procedure that does all of these things.