Index: doc/src/FAQ/FAQ.html
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v
retrieving revision 1.66
diff -c -r1.66 FAQ.html
*** doc/src/FAQ/FAQ.html 2001/04/27 00:55:49 1.66
--- doc/src/FAQ/FAQ.html 2001/05/07 19:50:27
***************
*** 112,118 ****
4.11) What is an R-tree index?
4.12) What is the Genetic Query Optimizer?
4.13) How do I perform regular expression
! searches and case-insensitive regular expression searches?
4.14) In a query, how do I detect if a field
is NULL?
4.15) What is the difference between the
--- 112,119 ----
4.11) What is an R-tree index?
4.12) What is the Genetic Query Optimizer?
4.13) How do I perform regular expression
! searches and case-insensitive regular expression searches? How do I
! use an index for case-insensitive searches?
4.14) In a query, how do I detect if a field
is NULL?
4.15) What is the difference between the
***************
*** 957,968 ****
search.
The ~ operator does regular expression matching, and ~* does case-insensitive regular expression matching. The case-insensitive variant of LIKE is called ILIKE in PostgreSQL 7.1 and later.
The ~ operator does regular expression matching, and ~* does case-insensitive regular expression matching. The case-insensitive variant of LIKE is called ILIKE in PostgreSQL 7.1 and later.
+ +Case-insensitive equality comparisons are normally expressed as: + +
+ SELECT * + FROM tab + WHERE lower(col) = 'abc' ++ + This will not use an standard index. However, if you create a + functional index, it will be used: + +
+ CREATE INDEX tabindex on tab (lower(col)); +