IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Does that work?
Post #139,417
by admin
Picture of admin
2/2/04 7:35:29 PM
Reply
New Does that work?
Can you use FOR with a cursor? I can only find references to using FOR with a select query.

If it works, you shouldn't have to open/close the cursor.

Also, it's "CLOSE", not "CLOASE"... ;-)
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #139,670
by tuberculosis
Picture of tuberculosis
2/3/04 11:00:15 PM
Reply
New Apparently not :-(
Functions are turning into a drag as the thing isn't checked until invoked. Kind of a bummer.

I've ended up tossing cursors and just doing for loops on the query.


.....To the future or to the past, to a time when thought is free, when men are different from one another and do not live alone -- to a time when truth exists and what is done cannot be undone:
.....From the age of uniformity, from the age of solitude, from the age of Big Brother, from the age of doublethink -- greetings!

     -- George Orwell, 1984
     Cursors and For Loop's on PGSQL - (tuberculosis) - (2) - Feb. 2, 2004, 07:10:20 PM EST
         Does that work? - (admin) - (1) - Feb. 2, 2004, 07:35:29 PM EST
             Apparently not :-( - (tuberculosis) - Feb. 3, 2004, 11:00:15 PM EST

And Bob's your uncle...
32 ms