On Mon, Jan 6, 2025 at 9:06 PM Tom Lane wrote:
> So in principle, you might get best results by defining your query
> with DECLARE CURSOR and then using PQsetSingleRowMode on the FETCH.
> But it'd really depend on the particular query whether this gives
> any benefit.
That's a really nice suggest
I've been using LibPQ to get data from PostgreSQL instances with great
success.
I'm using PQsendQuery and PQgetResult, but noticed there's
also PQsetSingleRowMode.
The documentation is clearly stating it only benefits a limited set of
scenario's, but I'm saddened that it can't help to get the first
