Re: [SQL] pgsql and cursor

2001-02-09 Thread Ian Lance Taylor
Najm Hashmi <[EMAIL PROTECTED]> writes: > Hi all, I am not sure If it is allowed to use cursor inside pgsql functions. > If it is possible, please someone could send exact synatx how it is used. If > it is not allowed is there a way arround it? I need to do some calculations > and then return t

Re: [SQL] pgsql and cursor

2001-02-09 Thread Jie Liang
I just know you can use implict cursor inside the plpgsql e.g declare rec record; begin FOR rec IN select_clause LOOP statements END LOOP; end; Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PRO