Re: [GENERAL] programming in pgsql

2006-01-10 Thread Jim C. Nasby
On Mon, Jan 09, 2006 at 10:13:12AM +, 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 functi

Re: [GENERAL] programming in pgsql

2006-01-09 Thread Richard Huxton
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 t

[GENERAL] programming in pgsql

2006-01-07 Thread Angshu Kar
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? select A from Bcluster where pvalue = 0.3--say we get A=8 select B, A_child from CClust