Message-ID: <319efe7106d8db21e3bfa0fdb60fa37aa59d331c.camel@cybertec.at>
Subject: Re: libpq simple SELECT
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: Wed, 17 Dec 2025 22:30:29 +0100
In-Reply-To: <CA+FnnTxvvSOWz0caeB1pewbAgAjRC2QHxvPJ5C+Y7p7usLbMZg@mail.gmail.com>
References: 
	<CA+FnnTzP_9Mh9S7NJL5WFJmbOi2wxw4g=MdoUo-SuXEp3Fyg-g@mail.gmail.com>
	 <b92c6822df72932379da29ded319391b81cb2cf8.camel@cybertec.at>
	 <CA+FnnTzWJtJwUjWBbm9naV9BUWdzTnQ8dKCtPOqaL0+1UOWcAQ@mail.gmail.com>
	 <3fd9c2859c323d6f894ccf660764f24dc3423181.camel@cybertec.at>
	 <CA+FnnTxvvSOWz0caeB1pewbAgAjRC2QHxvPJ5C+Y7p7usLbMZg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/319efe7106d8db21e3bfa0fdb60fa37aa59d331c.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-12-17 at 13:07 -0800, Igor Korot wrote:
> This is a comment:
>=20
> /*
> =C2=A0=C2=A0=C2=A0=C2=A0 * Our test case here involves using a cursor, fo=
r which we must be inside
> =C2=A0=C2=A0=C2=A0=C2=A0 * a transaction block.=C2=A0 We could do the who=
le thing with a single
> =C2=A0=C2=A0=C2=A0=C2=A0 * PQexec() of "select * from pg_database", but t=
hat's too trivial to make
> =C2=A0=C2=A0=C2=A0=C2=A0 * a good example.
> =C2=A0=C2=A0=C2=A0=C2=A0 */
>=20
> When I read it my understanding is:
>=20
> It is possible to write the code without a cursor..
> However it will be trivial and so the code will use CURSOR.
> But the usage of CURSOR is actually not required - it is used
> in the docs only to make a good example.
>=20
> However, when I tried to write the code without the CURSOR
> it seems that CURSOR usage is a must and not optional, which
> contradicts the comment above.
>=20
> I hope now my question is clear. I want to know if using CURSR
> is a must.

Sorry that it took me so long to understand what you mean.

Your PQexec call should return all rows.  If you don't get all rows, there
must be some other problem with your code.  You didn't show enough of the
code for me to see where the problem is.

Yours,
Laurenz Albe