is there any replacement for a cursor

Started by srinivasover 24 years ago2 messagesgeneral
Jump to latest
#1srinivas
srinivaschowdary@essemm.co.in

can iknow is there any replacement for a cursor in postgresql if soon
please send me the information as soon as u can.waiting for ur reply.
cheers
chowdary.

#2Keary Suska
hierophant@pcisys.net
In reply to: srinivas (#1)
Re: is there any replacement for a cursor

Not as easy a one. The next best alternative would be using a temporary
table and LIMIT clauses, but I am not sure how that compares performance
wide as well as why you want to avoid cursors in the first place. There has
been a discussion regarding maintaining a persistent selection for web
application use, where cursors aren't always the best soution.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

Show quoted text

From: srinivas <srinivaschowdary@essemm.co.in>
Date: Tue, 25 Sep 2001 11:25:25 +0530
To: "'pgsql-general@PostgreSQL.org'" <pgsql-general@postgresql.org>
Subject: [GENERAL] is there any replacement for a cursor

can iknow is there any replacement for a cursor in postgresql if soon
please send me the information as soon as u can.waiting for ur reply.
cheers
chowdary.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org