Matthew Lunnon <[EMAIL PROTECTED]> 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
