Thanks Roman for sticking with me on this! For whatever reason I cannot load another langage, I think it has to do with recompiling the program and installing all the options. Not sure though?? LANGUAGE plpgsql doesn't exist for me.
I still find this cursor limitation wacked. I find it hard to believe that nobody else is requiring this curosr funcionality. Why else have a cursor? See the bottom from this link http://www.postgresql.org/docs/7/interactive/sql-fetch.htm Even in there is display of a teaser that it can be done. Too bad there is no example. My objective is to look at each record one at at time from top to bottom. I need to take that information in variable form, and run it through a routine that is in the cursor block, then the end result needs to end up in another table. There will be times where I will also need to scroll forward and backward. I do understand, even though I don't agree with PostgreSQl approach to this, that my only alternative is to create a function. But as you know getting a function to work in the way I need it to will require custom functions. What a pain! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
