Skip site navigation (1) Skip section navigation (2)

PL/PgSQL Cursors vs. Pl/SQL Cursors

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: PL/PgSQL Cursors vs. Pl/SQL Cursors
Date: 2002-05-30 04:41:15
Message-ID: 20020530044115.64673.qmail@web20405.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi:

   I would like to know the difference between Oracle
cursors and PL/PgSQL Cursors.
 
   How does one loop through a cursor in postgres?

   Does postgres have "cursor attributes" that
indicates attributes such as is the cursor opened? is
it already the end of record? (i.e. similar to Oracle
%found, %rowcount cursor attributes?

thanks,
ludwig.

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

pgsql-novice by date

Next:From: Joshua b. JoreDate: 2002-05-30 06:43:18
Subject: Re: ideal filesystem layout
Previous:From: danixDate: 2002-05-30 03:58:09
Subject: ideal filesystem layout

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group