On Fri, 2005-04-01 at 04:32, Alban Hertroys wrote:
> Joseph M. Day wrote:
> > Just out of curiosity, what is the performance of this? In MSSQL the
> > only way to do something equivalent to this was to use a cursor. Cursors
> > are painfully slow, so they are to be used as a last resort.
>
> On what do you base that cursors are slow?
I'm guessing that in MSSQL, cursors are slow, so the original poster
simply assumed that on all other databases, cursors are slow.
I can assure him that in PostgreSQL they are not any slower than any
other method of accessing data i've used, and usually faster.