Re: [GENERAL] libpq: multiple commands within single query

2011-01-18 Thread Tom Lane
=?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

Re: [GENERAL] libpq: multiple commands within single query

2011-01-18 Thread Вячеслав Блинников
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

Re: [GENERAL] libpq: multiple commands within single query

2011-01-18 Thread Dmitriy Igrishin
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

[GENERAL] libpq: multiple commands within single query

2011-01-18 Thread Вячеслав Блинников
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

[GENERAL] libpq: multiple commands within single query

2011-01-15 Thread Вячеслав Блинников
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