Charles Joseph <[EMAIL PROTECTED]> writes:
> I face problem when running the following pgplsql
> function. The problem is it takes more than 24hours to
> complete
> the calculation. The EMP table has about 200,000
> records.
Sure there are no infinite loops of PARENT links in your table?
I face problem when running the following pgplsql
function. The problem is it takes more than 24hours to
complete
the calculation. The EMP table has about 200,000
records. I execute the function through psql "select
calculate()";
(There is no cyclic link inside the data).
Comp