Thread: PGresult

PGresult

From
"Vladimir V. Zolotych"
Date:
    Hello All,
Is it possible to have one PGresul inside another PGresult?
E.g. having some small PGresult while another (big) PGresult
still active?

PGresult* res1 = PQexec (,,,)
for (...............) {
  // do some processing with res1.
  PGresult* res2 = PQexec (...);
  // Process res2.
  PQclear (res2);
  // return back to res1
}

Thanks!
 

-- 
Vladimir Zolotych                         gsmith@eurocom.od.ua
 

Re: PGresult

From
Peter Eisentraut
Date:
Vladimir V. Zolotych writes:

> Is it possible to have one PGresul inside another PGresult?
> E.g. having some small PGresult while another (big) PGresult
> still active?
>
> PGresult* res1 = PQexec (,,,)
> for (...............) {
>   // do some processing with res1.
>   PGresult* res2 = PQexec (...);
>   // Process res2.
>   PQclear (res2);
>   // return back to res1
> }

res1 and res2 are completely independent, you can use both as long and
often as you want. Not sure how you want to "include" one in the other
though.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden