Prev: global temporary tables
Next: recovery_connections cannot start (was Re: [HACKERS] master in standby mode croaks)
From: Rod Taylor on 23 Apr 2010 23:27
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 functional index (
lower(citext_column) ).

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: global temporary tables
Next: recovery_connections cannot start (was Re: [HACKERS] master in standby mode croaks)