I need a function that does something like this pseudocode:
function get_data() RETURN SET OF something... as BEGIN myResultSet = select id, some_other_column from ...... limit 20000; update some_other_table set status = 2 where id in (myResultSet.id); RETURN QUERY myResultSet; END;
In other words, I need to execute a query, use the IDs I got in other update statement and then return this same query result.
I was wondering if there is a way to store a resultset in some kind of variable, but my research didn't find any good results. Any other kind of solution is appreciated, since I don't need to execute my same query twice.