From: | Kevin Duffy <kevind0718(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | row number with in cursor |
Date: | 2016-10-07 00:05:52 |
Message-ID: | CAHCyeW1VwGD5JYX4GhHj-Yr3Tmupnrb_onm2BX+Vopb84=Tf1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello All:
I need your kind assistance, to learn if it is possible
within a cursor to know what row you are on.
Something like this:
for currDateRate IN currDR( rate_in, start_date ) LOOP
raise notice ' currDateRate.rate_date: %', currDateRate.rate_date ;
raise notice ' currDateRate.lag_r_value: %', currDateRate.lag_r_value ;
raise notice ' currDateRate.rate_value: %', currDateRate.rate_value ;
raise notice ' currDateRate.overnight_r: %',
currDateRate.overnight_rate_return ;
tr_index := tr_index *( 1+ currDateRate.overnight_rate_return ) ;
raise notice ' tr_index: %',tr_index ;
-- this does NOT work
raise notice ' row number %', currDateRate%ROWNUMBER ;
End LOOP;
for testing purposes would like to break out after twenty records.
Yes I know I could do a simple counter like this:
rtn_cnt := rtn_cnt +1;
if rtn_cnt >= 20 then
return rtn_cnt;
END IF;
thamks for your attention to this matter
KD
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-10-07 00:26:55 | Re: row number with in cursor |
Previous Message | Bujji Babu | 2016-10-06 11:19:22 | Re: [BUGS] SQL Bug |