"Paul Mackay" <[EMAIL PROTECTED]> writes: > I understand that the query plan of a function is determined at > CREATION and remains the same whatever the parameter(s) value. I > suppose then that this plan is stored somewhere in a system table ?
You are misinformed. It's determined the first time that function is executed in a given backend, and stored in backend-local memory. There's no way that I know of to look at it. -Doug ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend