Angshu Kar wrote:
Hi Pgsql,
Could anyone please advise whether the following program can be implemented
using pgsql cursors/anythign else (or do we need some external scripts)?If
yes, could you give please some function names etc?
[snip series of queries]
Any procedural language will be able to handle this.
The only problem you'll have will be that the whole function will take
place inside a single transaction, so you won't be able to spread the
workload out over time.
--
Richard Huxton
Archonet Ltd
