Take a look at http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.htmland you'll find answer you need.
> I need to convert this cursor of Oracle to Postgres...> I wait for your help!!
-- Best regards, Yuri.