On Mon, Apr 11, 2016 at 7:15 PM, Karl O. Pinc <
kop@meme.com> wrote:
>
> Should I submit a regression test or something to ensure
> that this usage is officially supported? (A grep for
> PQsetSingleRowMode in src/test/ finds no hits.)
> Can I assume because it's documented it'll continue to work?
Pretty much.
> > Not sure about the part
> > where you call PQsetSingleRowMode() again after seeing
> > PGRES_TUPLES_OK: doesn't look to me like you need or want to do
> > that. You should only call it immediately after PQsendQuery().
>
> You're quite right. All but the first PQsetSingleRowMode()
> calls fail.
>
> This seems unfortunate. What if I submit several SQL statements
> with one PQsendQuery() call and I only want some of the statements
> executed in single row mode?
I would assume that if you know for which of the statements you want the single row mode, then you as well can submit them as separate PQsendQuery() calls.
> I'm not sure what the use case
> would be but it seems sad that PQsetSingleRowMode() is per
> libpq call and not per sql statement.
It is per query, where query == "argument to PQsendQuery()" :-)
> When the docs here say "query" what they really mean is "set of
> statements submitted in a single libpq call".
Which are the same things more or less, I'm not sure that the extended explanation you suggest makes it less confusing.
--
Regards,
Alex
