>From this site: http://developer.postgresql.org/pgdocs/postgres/citext.html I couldn't tell if you still had to create an index on the lower case value. It seems that it basically mimics the WHERE LOWER(email) = LOWER(?) method. Since this part is incredibly performance critical, maybe I'm better off storing my data all in lowercase and keeping the DB case sensitive. On Thu, Jun 10, 2010 at 2:29 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote: > Right now, I'm running 8.3.4 on Windows 2003, and I just used the MSI > installer to install it. > > On Thu, Jun 10, 2010 at 2:18 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> On Thu, Jun 10, 2010 at 3:16 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote: >>> Where do I get info on installing this? >> >> Very much depends on OS and how you installed pgsql >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
