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