Postgres Pro
Downloads
Home   >   mailing lists

Re: Index on immutable function call - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Index on immutable function call
Date
Msg-id B989CFBF-7989-40F1-8E95-ECE0D727A7A0@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: Index on immutable function call  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Index on immutable function call  (Tore Halvorsen <tore.halvorsen@gmail.com>)
Re: Index on immutable function call  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
On 19 Jan 2010, at 8:26, A. Kretschmer wrote:
> The planner doesn't know the actual parameter for the function, so he
> picked out the wrong plan. You can force the planner to re-planning with
> a dynamical statement within the function and EXECUTE that.


There are no queries in his function, I think you misread his post.

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.


!DSPAM:737,4b5579d610602488920658!

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Index on immutable function call
Next
From: Tore Halvorsen
Date:
Subject: Re: Index on immutable function call