On Mon, Jan 09, 2006 at 10:13:12AM +0000, Richard Huxton wrote: > 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. There are also other ways to do this. Celko presents one in "SQL For Smarties" based on setting up a graph (google:sql for smarties graph), and there is also contrib/ltree. Either of these is likely to perform much better than a heirarchy, unless you're doing a lot of inserts/updates/deletes (graphs) or need a lot of levels (ltree). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
