libpq: multiple commands within single query

From: Вячеслав Блинников <slavmfm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: libpq: multiple commands within single query
Date: 2011-01-18 11:24:45
Message-ID: AANLkTimdCPcu=ogZJekLHVtoGmtyPn8wTUeRn8dET6-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 expect some results (PGresult structure) for EACH
"SELECT" - so there must be 3 PGresult structures and if one of results
contains zero rows - it means that there are no data (of such type) for such
client yet, but there still can be some data for following "SELECT". For
example (referring to previous example) response can contain 3 results (as I
expect) where first contains 1 row, second 0 rows and third 1 row. So when I
examine the response I can match each PGresult to each "SELECT".
Does it works on this way? Or I missed something?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2011-01-18 11:55:36 Re: libpq: multiple commands within single query
Previous Message Muhammad Soultani 2011-01-18 10:57:45 read and restore deleted record