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
@postgresql.orgSubject:
[GENERAL] [PL/pgSQL] How should I use FOUND special variable. Documentation is
little unclear for meHello.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(st
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_audit_stats values(SEQ_SPM_ID_AUTO_INC.n
