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:
Rod Taylor p...@rbt.ca 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
On Fri, Apr 23, 2010 at 11:27 PM, Rod Taylor p...@rbt.ca 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
On 26 April 2010 11:19, Robert Haas robertmh...@gmail.com wrote:
On Fri, Apr 23, 2010 at 11:27 PM, Rod Taylor p...@rbt.ca 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,
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%';
This, of course, is equivalent to ILIKE 'Foo%' which does not appear
to be indexable without using a