On 11/9/06, Jeremiasz Miedzinski <[EMAIL PROTECTED]> wrote:
Now, I need to do the same action in PL/pgSQL. It's rather simple, but I
don't know how to use FOUND variable described in documentation:
FETCH retrieves the next row from the cursor into a target, which may be a
row variable, a record
Jeremiasz Miedzinski wrote:
Hello.
I'm porting some procedures from PL/SQL and I encountered following
problem:
In PL/SQL I'm using this statement related to cursor:
OPEN crs_cnt(start_millis, end_millis);
LOOP
FETCH crs_cnt into row_cnt;
EXIT WHEN crs_cnt%NOTFOUND;
insert into spm_aud
Title: Nachricht
Hi!
Just
use this:
FETCH crs_cnt into row_cnt;
EXIT WHEN NOT FOUND;
Greetings,
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jeremiasz MiedzinskiSent: Thursday, November
09, 2006 1:15 PMTo: pgsql-general@p
