Re: [HACKERS] CIText and pattern_ops

2010-05-26 Thread David E. Wheeler
Just picking up a dropped thread, does anyone have a patch for this? http://archives.postgresql.org/pgsql-hackers/2010-04/msg01191.php Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pg

Re: [HACKERS] CIText and pattern_ops

2010-04-26 Thread Thom Brown
On 26 April 2010 11:19, Robert Haas wrote: > On Fri, Apr 23, 2010 at 11:27 PM, Rod Taylor wrote: > > Is there any particular reason why the citext module doesn't have > > citext_pattern_ops operator family? > > You forgot to send in the patch. :-) > > ...Robert > > Yes, someone implementing thi

Re: [HACKERS] CIText and pattern_ops

2010-04-26 Thread Robert Haas
On Fri, Apr 23, 2010 at 11:27 PM, Rod Taylor wrote: > Is there any particular reason why the citext module doesn't have > citext_pattern_ops operator family? You forgot to send in the patch. :-) ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] CIText and pattern_ops

2010-04-26 Thread Takahiro Itagaki
Rod Taylor wrote: > Is there any particular reason why the citext module doesn't have > citext_pattern_ops operator family? > > Specifically, I wish to index for this type of query: > > ... WHERE citext_column LIKE 'Foo%'; I think it is a reasonable suggestion. =# \d tbl Table "public.t