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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])