diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-06-07 21:23:01 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-06-07 21:23:01 +0000 |
| commit | 877e296306a2017a18fc7086e9742c8ee3e0a665 (patch) | |
| tree | 38ed699f280dd72f118dd5b43000b7d0556ccdd8 /doc/FAQ | |
| parent | 9ca4c153bf7c9c9b8b067640e286bf867ea5b2ce (diff) | |
| download | postgresql-877e296306a2017a18fc7086e9742c8ee3e0a665.tar.gz | |
Spelling fix.
Robert Treat
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 10 |
1 files changed, 5 insertions, 5 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Jun 3 20:17:01 EDT 2006 + Last updated: Wed Jun 7 17:22:48 EDT 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -519,7 +519,7 @@ One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are rarely - needed. Uniqueness is best guaranteed by a funtion index of an MD5 + needed. Uniqueness is best guaranteed by a function index of an MD5 hash of the long column, and full text indexing allows for searching of words within the column. @@ -620,8 +620,8 @@ FROM tab WHERE lower(col) = 'abc'; - This will not use an standard index. However, if you create a - expresssion index, it will be used: + This will not use an standard index. However, if you create an + expression index, it will be used: CREATE INDEX tabindex ON tab (lower(col)); If the above index is created as UNIQUE, though the column can store @@ -726,7 +726,7 @@ 4.12) What is an OID? What is a CTID? Every row that is created in PostgreSQL gets a unique OID unless - created WITHOUT OIDS. OIDs are autotomatically assigned unique 4-byte + created WITHOUT OIDS. OIDs are automatically assigned unique 4-byte integers that are unique across the entire installation. However, they overflow at 4 billion, and then the OIDs start being duplicated. PostgreSQL uses OIDs to link its internal system tables together. |