I would like a way to run a function on all values returned from a query where the return value of the function is unimportant (even void in this case). A select statement may be the wrong way to do this so an alternative to using SELECT would also work.
This is what I cam up with for the time being which works but feels hacky:
SELECT * FROM ( SELECT foo.my_function(row_name) AS ignore FROM foo.my_table) AS ig WHERE ig.ignore IS NULL;
This gives me back 0 rows as I hoped for (instead of an empty row for every row in foo.my_table that the function was run on). Is there an easier way to achieve this?