Question : I’m trying to determine the performance characteristics of citext. In Microsoft SQL Server, the nvarchar(max) has performance hits […]
Tag: citext
WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
Question : The scenario Two systems(not server) running PHP and PostgreSQL with the following versions Fedora 15: PHP PHP 5.3.13 […]
Expression index on a citext column ignored, why?
Question : Running on RDS with about 32M rows. PostgreSQL 11.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red […]
Can I change CITEXT columns to VARCHAR without encountering any surprise difficulties?
Question : I went overboard on CITEXT columns on a particularly large table in my application. I would like to […]
Where do you find the citext module in postgres 9.3 on ubuntu 14.04?
Question : So I’m trying to use citext, but it appears to be MIA from ubuntu 14.04 postgres install. Where […]
How do I resolve Postgresql error, ‘no collation was derived for column “foo” with collatable type citext’?
Question : Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used pg_dump in the process. Now I’m getting […]
Why does a comparison between CITEXT and TEXT fail?
Question : As expected, when doing an equality test like this, the comparison succeeds: CREATE TABLE citext_test ( value citext […]