Returning results from many functions / statements

Question

I have a function that I will be running 10-50 times at once:

importsitechanges(33, 209703, 'Store Name', 'Addr', 'city', 'state', 'zip', 'phone')

This function that I made returns the number of changes made as a string.

When I run many of them at once in pgadmin, I only get the return string from the last one:

SELECT * FROM importsitechanges(33, 321344, 'Store Name', 'Addr', 'city', 'state', 'zip', 'phone');
SELECT * FROM importsitechanges(32, 209703, 'Store Name', 'Addr', 'city', 'state', 'zip', 'phone');
...

How can I get the return strings from all of these functions?

Answer 1

Unfortunately, as you already noticed, pgAdminIII shows only the latest result set. A logical solution could be transforming your 10-50 result sets into one. This can be achieved using UNION ALL:

SELECT * FROM importsitechanges(33, ...)
    UNION ALL
SELECT * FROM importsitechanges(22, ...)
    UNION ALL
...