MIME-Version: 1.0
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> <CAKFQuwZZjhpVcqun8ScEa7KJqK+bd0FXeKJuY3c21S1j1V=0Xg@mail.gmail.com>
In-Reply-To: <CAKFQuwZZjhpVcqun8ScEa7KJqK+bd0FXeKJuY3c21S1j1V=0Xg@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Wed, 17 Dec 2025 13:22:57 -0800
Message-ID: <CA+FnnTx42yOoax2VkXbEs1s=JnDORi72CAiT+BvW-jF7aiNV1A@mail.gmail.com>
Subject: Re: libpq simple SELECT
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTx42yOoax2VkXbEs1s%3DJnDORi72CAiT%2BBvW-jF7aiNV1A%40mail.gmail.com>
Precedence: bulk

David,,

On Wed, Dec 17, 2025 at 1:14=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Wednesday, December 17, 2025, Igor Korot <ikorot01@gmail.com> wrote:
>>
>>
>> I hope now my question is clear. I want to know if using CURSR
>> is a must.
>
>
> No it is not.  But there isn=E2=80=99t an example of doing so without a c=
ursor because it is deemed trivial enough that a competent C writer can fig=
ure it out.  In particular, it basically is just the same code as the =E2=
=80=9Cfetch=E2=80=9D portion of the example, but the select command is supp=
lied instead of a fetch command.  Both of those SQL commands result is tupl=
es being generated.

So what do I do after calling PQexec()? And why is my code running only onc=
e?

Thank you.

>
> David J.
>