=?KOI8-R?B?99HexdPMwdcg4szJzs7Jy8/X?= writes:
> Yeah - that is how I do (PGgetResult function returns results until it will
> return "NULL" pointer which means that all data for whole "PGsendQuery" was
> returned). But what does it mean when query which contain 3 "SELECT"
> commands returns just o
Yeah - that is how I do (PGgetResult function returns results until it will
return "NULL" pointer which means that all data for whole "PGsendQuery" was
returned). But what does it mean when query which contain 3 "SELECT"
commands returns just one result (second "PGgetResult()" already returns
null
Hey,
18 января 2011 г. 14:24 пользователь Вячеслав Блинников
написал:
> By which rules database returns results for multiple commands within single
> query?
> For example I send (execute) such query (obtain different information about
> just connected client):
> "SELECT column1 FROM table1; SELEC
By which rules database returns results for multiple commands within single
query?
For example I send (execute) such query (obtain different information about
just connected client):
"SELECT column1 FROM table1; SELECT column2 FROM table2; SELECT column3 FROM
table3;"
And when I get response I expe
When I call PQsendQuery(..., "SELECT column1 FROM my_table; SELECT column2
FROM my_table; SELECT column3 FROM my_table") PQgetResult(...) successfully
returns three results each containing 1 row and 1 column - that is what I
need.
But when I call something like PQsendQuery(..., "SELECT column1 FROM