2007/12/10, Piotr Gasidło <quaker@xxxxxxxxxxxxxx>:> Why PL/PGSQL is unable to proper utilize> users_user_name_unique_text_pattern_ops?
I found solution, that satisfies me (EXECUTE is a bit ugly for me).
I've replaced LIKE operator with ~=~ operator. Now PL/PGSQL functionproperly uses index on SELECT.
---------------------------(end of broadcast)---------------------------TIP 4: Have you searched our list archives?
http://archives.postgresql.org
