"Ловпаче Айдамир" <aidanet@yandex.ru> writes:
> create function get_fio1(text) returns varchar
> as 'select fio from patient_temp where fio like $1::text || \'%\';'
> language 'sql';
You won't get an indexscan for this because the LIKE pattern is not
a constant at planning time, and so the planner cannot extract indexscan
bounds from it.
In 7.1 it's possible to obtain the desired result in plpgsql, by using
EXECUTE. You'd need to substitute the pattern into the query string
as a literal constant, not as a plpgsql variable.
regards, tom lane