Richard Ray <rray@mstc.state.ms.us> writes:
> On Thu, 7 Dec 2006, Thomas Pundt wrote:
>> Just a guess: is the column "doc_num" really of type text? Maybe using "text"
>> in the function lets the planner choose a sequential scan?
> Actually "doc_num" is char(9)
> I changed text to char(9) and got same slow results
You need to make the second argument type "name", too, if you have a lot
of users.
regards, tom lane