Re: Bug(?) with cursors using aggregate functions.

Benjamin Scherrey <scherrey@proteus-tech.com> writes:
> I've been developing a web-based selection browser using cursors and
> discovered a very frustrating little feature as I try to MOVE
> FORWARD/BACKWARD through my selection.

You can't run a nontrivial query plan (anything more than a seqscan or
indexscan) backwards with any reliability.  There are fixes for this in
CVS tip, but not in any released version :-(.  It should also be noted
that the fix consists of saving-aside copies of all rows emitted by the
underlying query, so if you are talking about a large result set you
might not like the performance...

            regards, tom lane