Message-ID: <gh-postgresql-interfaces-psqlodbc-102-c2787364874@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Tue, 08 Apr 2025 18:42:32 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #102: Statement using WITH and INSERT does not work when UseDeclareFetch=1
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-102@github.com>
References: <gh-postgresql-interfaces-psqlodbc-102@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2787364874
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 102
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/102#issuecomment-2787364874
Content-Type: text/plain; charset=utf-8

> So, if I undestand it right, the ODBC allows you to limit the amout of lines to be retrieved, but since ODCB wraps libpq, and libpq behavior is "get entire result set at once" or "get result set row by row ", the only way to accomplish that is declare and open a cursor, and fetch the amount of data desired ( default 100 rows ) ?

it's not just libpq that does this. This is how the protocol works.