cursor manipulation

Cursor manipulation with select statements

This is something i did in foxpro and wonder if it is at all possible in
pl/pgSQL.  I would create a cursor in foxpro then populate it with
Inserts then after all that was done use a Select statement to do more
manipulation if need be

the Foxpro code would look something like this
---------------
Create Cursor plaything (cname char(10),  price n(14,4),  qty n(14,4))

For  i in SomeArrayofObjects
    insert into playting (i.Company, i.Price, i.qty)
end for

Select cName,  max(price*qty), avg(price * qty), min(price*avg)  from
plaything  group by Cname into cursor plaything2
----------------

After a cursor has been created can a Select statement see it or do i
have to create a temp table
thanks