> OK, so maybe it's dependent on the size of the table. Try generating a test case by loading up just your schema + functions + a lot of dummy entries generated by script. > Is the data proprietary? If not, maybe you could arrange to send me a dump off-list. A short test-case script would be better, but let's not waste huge amounts of person-time to save a few hours of downloading ...
That's what I was planning to do. I'll generate a table with dummy entries. I think we may try to use the smaller base table first. Once I can reproduce the problem I'll dump the database into a file and send it to you. Is there a server that I can upload the data to? Thanks again for your help. _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
