4 ms·
https://www.postgresql.org/docs/14/plpgsql-cursors.html https://www.postgresql.org/docs/14/plpgsql-cursors.html
by jayski 5y ago
https://www.postgresql.org/docs/14/plpgsql-cursors.html https://www.postgresql.org/docs/14/plpgsql-cursors.html
- djbusby 5y agoCursors are a for rows at a time. Sounds like above wants `Select *` but only magically pick the columns/fields used by the code.
- mike_hock 5y agoWhich would be possible, but not without the server round trips that he also seems to want to get rid of. Basically, he wants a bunch of complexity and heuristics to be pushed into the query planner, the client, and the protocol, just so he doesn't have to write the column names.