Thread: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 10:43 AM
=?ISO-8859-2?Q?Piotr_Gasid=B3o?=
 
Posts: n/a
Default Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
2007/12/10, Piotr Gasidło <quaker@barbara.eu.org>:
> 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 function
properly uses index on SELECT.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org
Reply With Quote