"M. Bastin" <marcbastin(at)mindspring(dot)com> writes:
> I'm reading the docs about the extended query language and the
> portals. Is it possible to use portals as a kind of concurrent
> cursors over a single TCP/IP connection?
> Or should you execute and close portals one after another and never
> execute the next portal before the previous one is closed? (Like
> regular transactions.)
You can certainly have multiple portals open and fetch from different
ones in turn; not clear if that's what you meant. A portal is more like
a SQL cursor than like a transaction.
regards, tom lane