libpq: multiple commands within single query

Поиск
Список
Период
Сортировка
От Вячеслав Блинников
Тема libpq: multiple commands within single query
Дата
Msg-id AANLkTimR=EKx7Z6i6arX8JFTnGKw_90xwV=JmPdJDJsc@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
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?

В списке pgsql-general по дате отправления:

Предыдущее
От: Randall Smith
Дата:
Сообщение: Trigger Performance
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Record with a field consisting of table rows