On Wed, Jan 19, 2005 at 01:46:33AM -0600, Thomas F.O'Connell wrote: > Follow-up question: are indexes used in dynamically executed queries? > > Rather than SEQSCAN or INDEXSCAN in the DETAIL item, I see RESULT > followed by a large amount of unreadable (by me) output. Are you sure you're looking at the right DETAIL? Adding some RAISE INFO or RAISE DEBUG statements can help you pinpoint which log output belongs to which part of the function. I just wrote a test function that used EXECUTE to do an UPDATE and a SELECT loop and saw INDEXSCAN in the relevant DETAIL sections. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
