|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated:Sat Jun3 20:17:01 EDT 2006</P> |
| 13 | +<P>Last updated:Wed Jun717:22:48 EDT 2006</P> |
14 | 14 |
|
15 | 15 | <P>Current maintainer: Bruce Momjian (<Ahref= |
16 | 16 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) |
@@ -694,7 +694,7 @@ <H3 id="item4.4">4.4) What is the maximum size for a row, a |
694 | 694 |
|
695 | 695 | <P>One limitation is that indexes can not be created on columns |
696 | 696 | longer than about 2,000 characters. Fortunately, such indexes are |
697 | | - rarely needed. Uniqueness is best guaranteed by afuntion index |
| 697 | + rarely needed. Uniqueness is best guaranteed by afunction index |
698 | 698 | of an MD5 hash of the long column, and full text indexing |
699 | 699 | allows for searching of words within the column.</P> |
700 | 700 |
|
@@ -812,8 +812,8 @@ <H3 id="item4.8">4.8) How do I perform regular expression |
812 | 812 | FROM tab |
813 | 813 | WHERE lower(col) = 'abc'; |
814 | 814 | </PRE> |
815 | | - This will not use an standard index. However, if you createa |
816 | | -expresssion index, it will be used: |
| 815 | + This will not use an standard index. However, if you createan |
| 816 | +expression index, it will be used: |
817 | 817 | <PRE> |
818 | 818 | CREATE INDEX tabindex ON tab (lower(col)); |
819 | 819 | </PRE> |
@@ -957,7 +957,7 @@ <H3 id="item4.12">4.12) What is an <SMALL>OID</SMALL>? What is |
957 | 957 |
|
958 | 958 | <P>Every row that is created in PostgreSQL gets a unique |
959 | 959 | <SMALL>OID</SMALL> unless created<SMALL>WITHOUT OIDS</SMALL>. |
960 | | - O<SMALL>ID</SMALL>s areautotomatically assigned unique 4-byte |
| 960 | + O<SMALL>ID</SMALL>s areautomatically assigned unique 4-byte |
961 | 961 | integers that are unique across the entire installation. However, |
962 | 962 | they overflow at 4 billion, and then the O<SMALL>ID</SMALL>s start |
963 | 963 | being duplicated. PostgreSQL uses<SMALL>OID</SMALL>s to link its |
|