"Grzegorz Taczyk" <goliatus(at)polzone(dot)pl> writes:
> SELECT * FROM table WHERE id = myfunction('x', 10);
> There is an index created on id column, but query planner doesn't use it.
Have you declared myfunction as IMMUTABLE or STABLE? If it's volatile
then optimizing to an indexscan is incorrect and the planner won't do it.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-12-27 15:29:55|
|Subject: Re: BUG #2125: SELECT problem with strings containing \ |
|Previous:||From: Tom Lane||Date: 2005-12-27 15:22:28|
|Subject: Re: BUG #2127: Regular Expression Limits Do Not Work |