From: | Justin <justin(at)emproshunts(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | cursor manipulation |
Date: | 2008-03-21 05:43:53 |
Message-ID: | 47E34B19.9070508@emproshunts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | lak | 2008-03-21 09:33:24 | Table size |
Previous Message | Brendan Jurd | 2008-03-21 03:02:39 | Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[] |