Matthew Lunnon <mlunnon@xxxxxxxxxxxxx> writes: > Is there any way to work out what plan the query is using in side the > function? I think I have a similar problem with a query taking much > longer from inside a function than it does as a select statement. Standard approach is to PREPARE a statement that has parameters in the same places where the function uses variables/parameters, and then use EXPLAIN [ANALYZE] EXECUTE to test it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
