Search Postgresql Archives

Re: Cursor loop - stop current iteration and continue with next iteration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Dec 21, 2011, at 0:36, Dinesh Kumara <dinesh@xxxxxxxxxxxxxx> wrote:

Greetings..

Please advice me how to stop current iteration of cursor loop and continue with next iteration .

...
contractlistquery = '....';
OPEN rec_contractlist FOR EXECUTE contractlistquery;
    LOOP
    FETCH rec_contractlist INTO  contract_from_date,contract_to_date,contract_inv_type,contract_regionid;
    IF NOT FOUND THEN
    EXIT;
    END IF;

    IF contract_count = 0 THEN
        contract_initial_region = contract_regionid;
    END IF;

        IF contract_initial_region <> contract_regionid THEN
           
[Need to stop current iteration and continue with next iteration.]
       ELSE
        ...
        More  logic s here...
        ...
        END IF;

    END LOOP;
CLOSE rec_contractlist;

...

Really appreciate if you can help me on this.
--

Thanks and Regards,
Dinesh Kumara,
Software Engineer,
Reservation Gateway Inc,
Email:dinesh@xxxxxxxxxxxxxx
www.rezgateway.com

<image002.png>

See

39.6.3.3

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux