Cursors in PL/pgSQL - Mailing list pgsql-novice

From Rob
Subject Cursors in PL/pgSQL
Date
Msg-id Pine.LNX.4.33L2.0202071614090.7925-100000@Genesis
Whole thread Raw
Responses Re: Cursors in PL/pgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Is there any way to declare a cursor in  PL/pgSQL.

Basically I need to write a store proc that cycles through a table row by
row and terminates at the last row.  Do I have to write it in  using
PL/pgSQL (PL/pgSQL won't let me use many of the normal sql keywords) and,
if I do, how do I cycle through a table?

Thanks

Rob

--
He who dies with the most toys ...

                    ... still dies


pgsql-novice by date:

Previous
From: Walter Hop
Date:
Subject: Re: can't connect to postmaster from other machine
Next
From: FOlkeN
Date:
Subject: Re: can't connect to postmaster from other machine