Convert Chinese FAQ to valid XHTML, finally.

1 files changed, 68 insertions, 75 deletions

diff --git a/doc/FAQ_chinese b/doc/FAQ_chinese
index e39c0c77a9f..cae9589bd55 100644
--- a/doc/FAQ_chinese
+++ b/doc/FAQ_chinese
@@ -141,7 +141,7 @@
    
    £¨Portions copyright (c) 1996-2002, PostgreSQL Global Development
    Group
-    Portions Copyright (c) 1994-6 Regents of the University of
+   Portions Copyright (c) 1994-6 Regents of the University of
    California£©
    
    ÔÊÐíΪÈκÎÄ¿µÄʹÓ㬿½±´£¬Ð޸ĺͷַ¢Õâ¸öÈí¼þºÍËüµÄÎĵµ¶ø²»ÊÕÈ¡ÈκηÑÓÃ
@@ -277,7 +277,7 @@
    µÄÊé½ÌÊÚ SQL¡££¨Òë×¢£ºÎÒÏÂÔص½±¾µØÁË¡££©ÔÚ
    http://www.commandprompt.com/ppbook ÓÐÁíÍâÒ»±¾¹ØÓÚ PostgreSQL
    µÄÊé¡£ÔÚhttp://www.intermedia.net/support/sql/sqltut.shtm£¬http://ourw
-   orld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM  ºÍ
+   orld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM ºÍ
    http://sqlcourse.com ÓÐÒ»¸ö²»´íµÄÈëÃŽ̡̳£
    
    ÁíÒ»¸öÊÇ "Teach Yourself SQL in 21 Days, Second
@@ -320,7 +320,6 @@
           ͸´ÔÓµÄËøµÈ¡£ÎÒÃÇ»¹ÓÐһЩËüÃÇûÓеÄÌØÐÔ£¬ÈçÓû§¶¨ÒåÀàÐÍ£¬¼Ì³Ð£¬
           ¹æÔòºÍ¶à°æ±¾²¢ÐпØÖÆÒÔ¼õÉÙËøµÄÕùÓõȡ£
           
-          
    ÐÔÄÜ
           PostgreSQL
           ºÍÆäËûÉÌÓúͿªÔ´µÄÊý¾Ý¿â¾ßÓÐÀàËƵÄÐÔÄÜ¡£¶ÔijЩ´¦ÀíËü±È½Ï¿ì£¬¶ÔÆ
@@ -338,7 +337,6 @@
           ²âÊÔ£¬²¢ÇÒÎÒÃǵķ¢²¼ÀúÊ·ÏÔʾÎÒÃÇ¿ÉÒÔÌṩÎȶ¨µÄ£¬Àι̵ģ¬¿ÉÓÃÓÚÉ
           ú²úʹÓõİ汾¡£ÎÒÃÇÏàÐÅÔÚÕâ·½ÃæÎÒÃÇÓëÆäËûµÄÊý¾Ý¿âÈí¼þÊÇÏ൱µÄ¡£
           
-          
    Ö§³Ö
           ÎÒÃǵÄÓʼþÁбíÌṩһ¸ö·Ç³£´óµÄ¿ª·¢ÈËÔ±ºÍÓû§µÄ×éÒÔ°ïÖú½â¾öËùÅöµ
           ½µÄÈκÎÎÊÌâ¡£ÎÒÃDz»Äܱ£Ö¤¿Ï¶¨Äܽâ¾öÎÊÌ⣬Ïà±È֮ϣ¬ÉÌÓà DBMS
@@ -347,7 +345,6 @@
           »¹ÒªºÃ¡£»¹ÓÐһЩÉÌÒµÐÔµÄÔ¤°ü×°µÄÖ§³Ö£¬¿ÉÒÔ¸øÌṩ¸øÄÇЩÐèÒªµÄÈË¡
           ££¨²ÎÔÄÖ§³Ö FAQ Ìõ¿î 1.6 С½Ú¡££©
           
-          
    ¼Û¸ñ
           ÎÒÃǶÔÈκÎÓÃ;¶¼Ãâ·Ñ£¬°üÀ¨ÉÌÓúͷÇÉÌÓÃÄ¿µÄ¡£Äã¿ÉÒÔ²»¼ÓÏÞÖƵØÏòÄ
           ãµÄ²úÆ·Àï¼ÓÈëÎÒÃǵĴúÂ룬³ýÁËÄÇЩÎÒÃÇÔÚÉÏÃæµÄ°æȨÉùÃ÷ÀïÉùÃ÷µÄ
@@ -667,7 +664,7 @@
    
     4.7) ÈçºÎ²é¿´±í¡¢Ë÷Òý¡¢Êý¾Ý¿âÒÔ¼°Óû§µÄ¶¨Ò壿
     
-    psql ÓÐÐí¶à·´Ð±¸ÜÃüÁîÓÃÓÚÏÔʾÕâЩÐÅÏ¢¡£Óà \? ¿´¿´¶¼ÓÐÄÄЩ¡£ÒÔ pg_
+   psql ÓÐÐí¶à·´Ð±¸ÜÃüÁîÓÃÓÚÏÔʾÕâЩÐÅÏ¢¡£Óà \? ¿´¿´¶¼ÓÐÄÄЩ¡£ÒÔ pg_
    ´òÍ·µÄϵͳ±íÒ²ÃèÊöÁËÕâЩÐÅÏ¢¡£ psql -l ¿ÉÒÔÁгöËùÓеÄÊý¾Ý¿â¡£
    
    Ò²¿ÉÒÔÊÔÊÔÎļþ
@@ -692,10 +689,10 @@
    ³£»áʹÓÃË÷Òý£¬ÒòΪֻ»á·µ»Ø±íµÄһС²¿·Ö¡£Êµ¼ÊÉÏ£¬ËäÈ» MAX() ºÍ MIN()
    ²¢²»Ê¹ÓÃË÷Òý£¬Í¨¹ý¶Ô ORDER BY ºÍ LLIMIT
    ʹÓÃË÷ÒýÈ¡µÃ×î´óÖµºÍ×îСֵҲÊÇ¿ÉÒԵģº
-       SELECT col
-       FROM tab
-       ORDER BY col [ DESC ]
-       LIMIT 1;
+   SELECT col
+   FROM tab
+   ORDER BY col [ DESC ]
+   LIMIT 1;
    
    µ±Ê¹ÓÃͨÅä·û²Ù×÷£¬ÀýÈç LIKE »ò ~ ʱ£¬Ë÷ÒýÖ»ÄÜÔÚÌض¨µÄÇé¿öÏÂʹÓãº
      * ×Ö·û´®µÄ¿ªÊ¼²¿·Ö±ØÐëÊÇÆÕͨ×Ö·û´®£¬Ò²¾ÍÊÇ˵£º
@@ -740,11 +737,11 @@
    ²Ù×÷·û ~ ´¦ÀíÕýÔò±í´ïʽƥÅ䣬¶ø ~*
    ´¦Àí´óСдÎ޹صÄÕýÔò±í´ïʽƥÅä¡£´óдЩÎÞ¹ØµÄ LIKE ±äÖÖ³ÉΪ ILIKE¡£
    ´óСдÎ޹صĵÈʽ±È½Ïͨ³£Ð´×ö£º
-       SELECT *
-       FROM tab
-       WHERE lower(col) = 'abc';
+   SELECT *
+   FROM tab
+   WHERE lower(col) = 'abc';
    ÕâÑù½«²»»áʹÓñê×¼µÄË÷Òý¡£µ«ÊÇ¿ÉÒÔ´´½¨Ò»¸ö¿É±»ÀûÓõĺ¯ÊýË÷Òý:
-       CREATE INDEX tabindex ON tab (lower(col));
+   CREATE INDEX tabindex ON tab (lower(col));
    
     4.13) ÔÚÒ»¸ö²éѯÀÎÒÔõÑù¼ì²âÒ»¸ö×Ö¶ÎÊÇ·ñΪ NULL£¿
     
@@ -752,15 +749,14 @@
    
     4.14) ¸÷ÖÖ×Ö·ûÀàÐÍÖ®¼äÓÐʲô²»Í¬£¿
     
-     ÀàÐÍ            ÄÚ²¿Ãû³Æ    ˵Ã÷
-     --------------------------------------------------
-     "char"        char         1¸ö×Ö·û character
-     CHAR(#)      bpchar
-   ¶¨³¤×Ö·û´®£¬Êµ¼ÊÊý¾Ý²»×㶨Ò峤¶Èʱ£¬ÒÔ¿Õ¸ñ²¹Æë
-     VARCHAR(#)  varchar
+   ÀàÐÍ ÄÚ²¿Ãû³Æ ˵Ã÷
+   --------------------------------------------------
+   "char" char 1¸ö×Ö·û character
+   CHAR(#) bpchar ¶¨³¤×Ö·û´®£¬Êµ¼ÊÊý¾Ý²»×㶨Ò峤¶Èʱ£¬ÒÔ¿Õ¸ñ²¹Æë
+   VARCHAR(#) varchar
    Ö¸¶¨ÁË×î´ó³¤¶È£¬±ä³¤×Ö·û´®£¬²»×㶨Ò峤¶ÈµÄ²¿·Ö²»²¹Æë
-     TEXT           text         ´®³¤¶È½öÊÜÐеÄ×î´ó³¤¶ÈÏÞÖÆ
-     BYTEA          bytea       ±ä³¤×Ö½ÚÐòÁУ¨±ä³¤µÄ¶þ½øÖÆÊý¾Ý£©
+   TEXT text ´®³¤¶È½öÊÜÐеÄ×î´ó³¤¶ÈÏÞÖÆ
+   BYTEA bytea ±ä³¤×Ö½ÚÐòÁУ¨±ä³¤µÄ¶þ½øÖÆÊý¾Ý£©
    ÔÚϵͳ±íºÍÔÚһЩ´íÎóÐÅÏ¢ÀïÄ㽫¿´µ½ÄÚ²¿Ãû³Æ¡£
    ÉÏÃæ×îºóËÄÖÖÀàÐÍÊÇ"varlena"£¨±ä³¤£©ÀàÐÍ£¨Ò²¾ÍÊÇ˵£¬¿ªÍ·µÄËĸö×Ö½ÚÊdz¤¶
    È£¬ºóÃæ²ÅÊÇÊý¾Ý£©¡£ÓÚÊÇʵ¼ÊÕ¼ÓõĿռä±ÈÉùÃ÷µÄ´óСҪ¶àһЩ¡£È»¶øÕâЩÀàÐ
@@ -776,18 +772,17 @@
     
    PostgreSQL Ö§³Ö SERIAL
    Êý¾ÝÀàÐÍ¡£ËüÔÚ×Ö¶ÎÉÏ×Ô¶¯´´½¨Ò»¸öÐòÁкÍË÷Òý¡£ÀýÈ磬
-       CREATE TABLE person (
-           id SERIAL,
-           name TEXT
-           );
+   CREATE TABLE person (
+   id SERIAL,
+   name TEXT
+   );
    »á×Ô¶¯×ª»»Îª£º
-   
-       CREATE SEQUENCE person_id_seq;
-       CREATE TABLE person (
-           id INT4 NOT NULL DEFAULT nextval('person_id_seq'),
-           name TEXT
-           );
-       CREATE UNIQUE INDEX person_id_key ON person ( id );
+   CREATE SEQUENCE person_id_seq;
+   CREATE TABLE person (
+   id INT4 NOT NULL DEFAULT nextval('person_id_seq'),
+   name TEXT
+   );
+   CREATE UNIQUE INDEX person_id_key ON person ( id );
    ²Î¿¼ create_sequence ÊÖ²áÒ³»ñÈ¡¹ØÓÚÐòÁеĸü¶àÐÅÏ¢¡£Ä㻹¿ÉÒÔÓÃÿÐеÄ
    oid ×Ö¶Î×÷Ϊһ¸öΨһֵ¡£²»¹ý£¬Èç¹ûÄãÐèÒªÇãµ¹ºÍÖØÔØÊý¾Ý¿â£¬ÄãÐèҪʹÓÃ
    pg_dump µÄ -o Ñ¡Ïî»òÕß COPY WITH OIDS Ñ¡ÏîÒÔ±£Áô OID¡£
@@ -796,8 +791,8 @@
     
    Ò»ÖÖ·½·¨ÊÇÔÚ²åÈë֮ǰÏÈÓú¯Êý nextval() ´ÓÐòÁжÔÏóÀï¼ìË÷³öÏÂÒ»¸ö SERIAL
    Öµ£¬È»ºóÔÙÏÔʽ²åÈ롣ʹÓà 4.15.1 ÀïµÄÀý±í£¬¿ÉÓÃαÂëÕâÑùÃèÊö£º
-       new_id = execute("SELECT nextval('person_id_seq')");
-       execute("INSERT INTO person (id, name) VALUES (new_id, 'Blaise
+   new_id = execute("SELECT nextval('person_id_seq')");
+   execute("INSERT INTO person (id, name) VALUES (new_id, 'Blaise
    Pascal')");
    ÕâÑù»¹ÄÜÔÚÆäËû²éѯÖÐʹÓôæ·ÅÔÚ new_id ÀïµÄÐÂÖµ£¨ÀýÈ磬×÷Ϊ person
    ±íµÄÍâ¼ü£©¡£×¢Òâ×Ô¶¯´´½¨µÄ SEQUENCE ¶ÔÏóµÄÃû³Æ½«»áÊÇ
@@ -805,8 +800,8 @@
    ·Ö±ðÊÇÄãµÄ±íµÄÃû³ÆºÍÄãµÄ SERIAL ×ֶεÄÃû³Æ¡£
    ÀàËƵģ¬ÔÚ SERIAL ¶ÔÏóȱʡ²åÈëºóÄã¿ÉÒÔÓú¯Êý currval() ¼ìË÷¸Õ¸³ÖµµÄ
    SERIAL Öµ£¬ÀýÈ磬
-       execute("INSERT INTO person (name) VALUES ('Blaise Pascal')");
-       new_id = execute("SELECT currval('person_id_seq')");
+   execute("INSERT INTO person (name) VALUES ('Blaise Pascal')");
+   new_id = execute("SELECT currval('person_id_seq')");
    ×îºó£¬Äã¿ÉÒÔʹÓÃ´Ó INSERT Óï¾ä·µ»ØµÄ OID
    ²éÕÒȱʡֵ£¬¾¡¹ÜÕâ¿ÉÄÜÊÇ×îȱ·¦ÒÆÖ²ÐԵķ½·¨¡£ÔÚ Perl ÀʹÓôøÓÐ
    Edmund Mergl µÄ DBD::Pg Ä£¿éµÄ DBI£¬oid Öµ¿ÉÒÔͨ¹ý $sth->execute()
@@ -836,11 +831,11 @@
    Öµ¡£¿ÉÒÔÔÚ OID ×Ö¶ÎÉÏ´´½¨Ò»¸öË÷ÒýÒÔ¿ìËÙ·ÃÎÊ¡£
    OID ´ÓÒ»¸ö±»ËùÓÐÊý¾Ý¿âʹÓõÄÖÐÐÄÇøÓòÀ︳ֵ¸øËùÓÐÐÂÐС£Èç¹ûÄãÏë°Ñ OID
    ¸Ä³É±ðµÄÖµ£¬»òÕßÏë×öÒ»·Ý±íµÄ´øÔʼ OID µÄ¿½±´£¬Äã¿ÉÒÔ×öµ½£º
-       CREATE TABLE new(old_oid oid, mycol int);
-       SELECT old_oid, mycol INTO new FROM old;
-       COPY new TO '/tmp/pgtable';
-       DELETE FROM new;
-       COPY new WITH OIDS FROM '/tmp/pgtable';
+   CREATE TABLE new(old_oid oid, mycol int);
+   SELECT old_oid, mycol INTO new FROM old;
+   COPY new TO '/tmp/pgtable';
+   DELETE FROM new;
+   COPY new WITH OIDS FROM '/tmp/pgtable';
    OID
    ÓÃ4×Ö½ÚµÄÕûÊý±£´æ£¬ÔÚ³¬¹ý40ÒÚʱ½«Òç³ö¡£Ã»ÓÐÈ˱¨¸æ³öÏÖ¹ýÒç³ö£¬¶øÎÒÃÇ´òË
    ãÔÚÓÐÈ˱¨¸æ֮ǰÏû³ýÕâ¸öÏÞÖÆ¡£
@@ -851,15 +846,15 @@
     
    һЩԴ´úÂëºÍһЩ¾ÉÒ»µãµÄÎĵµÊ¹ÓÃһЩÓиü³£ÓÃÓ÷¨µÄÊõÓï¡£ÏÂÃæÊÇÆäÖÐÒ»²¿
    ·Ö£º
-       table, relation, class
-       row, record, tuple
-       column, field, attribute
-       retrieve, select
-       replace, update
-       append, insert
-       OID, serial value
-       portal, cursor
-       range variable, table name, table alias
+   table, relation, class
+   row, record, tuple
+   column, field, attribute
+   retrieve, select
+   replace, update
+   append, insert
+   OID, serial value
+   portal, cursor
+   range variable, table name, table alias
    ÓÐÒ»¸öͨÓÃÊý¾Ý¿âÊõÓïµÄÁÐ±í£ºhttp://hea-www.harvard.edu/MST/simul/softw
    are/docs/pkgs/pgsql/glossary/glossary.html ¡£
    
@@ -867,8 +862,8 @@
     
    ÕâºÜ¿ÉÄÜÊÇϵͳµÄÐéÄâÄÚ´æÓùâÁË£¬»òÕßÄں˶ÔijЩ×ÊÔ´Óнϵ͵ÄÏÞÖÆÖµ¡£ÔÚÆô
    ¶¯ postmaster ֮ǰÊÔÊÔÏÂÃæµÄÃüÁ
-       ulimit -d 262144
-       limit datasize 256m
+   ulimit -d 262144
+   limit datasize 256m
    È¡¾öÓÚÄãÓõÄ
    shell£¬ÉÏÃæÃüÁîÖ»ÓÐÒ»ÌõÄܳɹ¦£¬µ«ÊÇËü½«°ÑÄãµÄ½ø³ÌÊý¾Ý¶ÎÏÞÖÆÉèµÃ±È½Ï¸ß£
    ¬Òò¶øÒ²ÐíÄÜÈòéѯÍê³É¡£ÕâÌõÃüÁîÓ¦ÓÃÓÚµ±Ç°½ø³Ì£¬ÒÔ¼°ËùÓÐÔÚÕâÌõÃüÁîÔËÐк
@@ -894,32 +889,31 @@
     4.21) ÎÒÈçºÎ´´½¨Ò»¸öȱʡֵÊǵ±Ç°Ê±¼äµÄ×ֶΣ¿
     
    ʹÓà CURRENT_TIMESTAMP£º
-       CREATE TABLE test(x int, modtime timestamp DEFAULT
-   CURRENT_TIMESTAMP);
+   CREATE TABLE test(x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP);
    
     4.22) ΪʲôʹÓà IN µÄ×Ó²éѯÕâôÂý£¿
     
    Ä¿Ç°£¬ÎÒÃÇͨ¹ýΪÍâ²éѯµÄÿһÐÐ˳ÐòɨÃè×Ó²éѯµÄ½á¹ûÀ´Á¬½Ó×Ó²éѯºÍÍâ²éѯ
    ¡£Èç¹û×Ó²éѯ·µ»ØÉÙÊý¼¸ÐУ¬¶øÍâ²éѯ·µ»ØºÜ¶àÐУ¬IN
    Ö´Ðеúܿ졣ΪÁ˼ӿìÆäËû IN ²éѯµÄÖ´ÐУ¬¿ÉÒÔÓà EXISTS Ìæ»» IN£º
-       SELECT *
-       FROM tab
-       WHERE col IN (SELECT subcol FROM subtab);
+   SELECT *
+   FROM tab
+   WHERE col IN (SELECT subcol FROM subtab);
    ¸ÄΪ£º
-       SELECT *
-       FROM tab
-       WHERE EXISTS (SELECT subcol FROM subtab WHERE subcol = col);
+   SELECT *
+   FROM tab
+   WHERE EXISTS (SELECT subcol FROM subtab WHERE subcol = col);
    ºóÕßÒªÏëÖ´Ðеøü¿ì£¬subcol
    Ó¦¸ÃÊÇÒ»¸öË÷ÒýÁС£ÎÒÃÇÏ£ÍûÔÚδÀ´µÄ·¢²¼°æ±¾ÖÐÐÞ²¹Õâ¸öÏÞÖÆ¡£
    
     4.23) ÎÒÔõÑù½øÐÐ outer join £¨ÍâÁ¬½Ó£©£¿
     
    PostgreSQL ²ÉÓñê×¼µÄ SQL Óï·¨Ö§³ÖÍâÁ¬½Ó¡£ÕâÀïÊÇÁ½¸öÀý×Ó£º
-       SELECT *
-       FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);
+   SELECT *
+   FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);
    »ò
-       SELECT *
-       FROM t1 LEFT OUTER JOIN t2 USING (col);
+   SELECT *
+   FROM t1 LEFT OUTER JOIN t2 USING (col);
    ÕâÁ½¸öµÈ¼ÛµÄ²éѯÔÚ t1.col ºÍ t2.col ÉÏ×öÁ¬½Ó£¬²¢ÇÒ·µâ»?t1
    ÖÐËùÓÐδÁ¬½ÓµÄÐУ¨ÄÇЩÔÚ t2 ÖÐûÓÐÆ¥ÅäµÄÐУ©¡£ÓÒ[Íâ]Á¬½Ó(RIGHT OUTER
    JOIN)½«·µ»Ø t2 ÖÐδÁ¬½ÓµÄÐС£ÍêÈ«ÍâÁ¬½Ó£¨FULL OUTER JOIN£©½«·µ»Ø t1 ºÍ
@@ -928,14 +922,14 @@
    £¨INNER JOIN£©¡£
    ÔÚ´ËÇ°µÄ°æ±¾ÖУ¬ÍâÁ¬½Ó¿ÉÒÔÓà UNION ºÍ NOT IN
    À´Ä£Äâ¡£ÀýÈ磬ÏÂÃæµÄÀý×ÓÔÚ±í tab1 ºÍ tab2 Ö®¼ä×öÍâÁ¬½Ó£º
-       SELECT tab1.col1, tab2.col2
-       FROM tab1, tab2
-       WHERE tab1.col1 = tab2.col1
-       UNION ALL
-       SELECT tab1.col1, NULL
-       FROM tab1
-       WHERE tab1.col1 NOT IN (SELECT tab2.col1 FROM tab2)
-       ORDER BY col1
+   SELECT tab1.col1, tab2.col2
+   FROM tab1, tab2
+   WHERE tab1.col1 = tab2.col1
+   UNION ALL
+   SELECT tab1.col1, NULL
+   FROM tab1
+   WHERE tab1.col1 NOT IN (SELECT tab2.col1 FROM tab2)
+   ORDER BY col1
    
     4.24) ÈçºÎʹÓÃÉæ¼°¶à¸öÊý¾Ý¿âµÄ²éѯ£¿
     
@@ -961,8 +955,7 @@
     4.27) ÓÐÄÄЩÊý¾Ý¸´ÖÆÑ¡Ï
     
    Óм¸ÖÖÖ÷/´Ó·½Ê½µÄ¸´ÖÆÑ¡Ïî¡£ÕâЩѡÏîÖ»ÔÊÐíÖ÷Êý¾Ý¿â½øÐиüУ¬´ÓÊý¾Ý¿âÖ»Ä
-   ܽøÐжÁ¡£ÍøÒ³
-   http://gborg.PostgreSQL.org/genpage?replication_research
+   ܽøÐжÁ¡£ÍøÒ³ http://gborg.PostgreSQL.org/genpage?replication_research
    µÄ×îºóÁгöÁËÕâЩѡÏî¡£ÔÚ
    http://gborg.PostgreSQL.org/project/pgreplication/projdisplay.php
    ÕýÔÚ½øÐÐÒ»¸ö¶àÖ÷±¾¸´ÖƵĽâ¾ö·½°¸¡£