Search Postgresql Archives

libpq: multiple commands within single query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 my_table; SELECT some_bad_column_name FROM my_table, SELECT column2 FROM my_table; SELECT column3 FROM my_table") PQgetResult(...) returns just 2 results: first containing 1 row and 1 column and second containing 0 rows and 0 columns.
Is it somehow possible to get two remaining results?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux