On Fri, Aug 29, 2003 at 11:34:13AM -0400, Bill Moran wrote: > Have any explanation as to why that function is so slow?
Sorry, no. It might have to do with the planning, though. I believe the funciton is planned the first time it is run. It may need to be marked as "STABLE" in order to use any indexes, and that could be part of the problem. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match