@@ -53,8 +53,8 @@ <H2>User Client Questions</H2>
5353</ CENTER >
5454< A href ="#2.1 "> 2.1</ A > ) Are there< SMALL > ODBC</ SMALL > drivers for
5555 PostgreSQL?< BR >
56- < A href ="#2.2 "> 2.2</ A > ) What tools are available for use PostgreSQL
57- with Web pages?< BR >
56+ < A href ="#2.2 "> 2.2</ A > ) What tools are available for use
57+ PostgreSQL with Web pages?< BR >
5858< A href ="#2.3 "> 2.3</ A > ) Does PostgreSQL have a graphical user
5959 interface? A report generator? An embedded query language
6060 interface?< BR >
@@ -103,16 +103,16 @@ <H2>Operational Questions</H2>
103103 database?< BR >
104104< A href ="#4.7 "> 4.7</ A > ) How much database disk space is required
105105 to store data from a typical text file?< BR >
106- < A href ="#4.8 "> 4.8</ A > ) How do I find out what tables or
107- indexes are defined in the database?< BR >
106+ < A href ="#4.8 "> 4.8</ A > ) How do I find out what tables or indexes
107+ are defined in the database?< BR >
108108< A href ="#4.9 "> 4.9</ A > ) My queries are slow or don't make use of
109109 the indexes. Why?< BR >
110110< A href ="#4.10 "> 4.10</ A > ) How do I see how the query optimizer is
111111 evaluating my query?< BR >
112112< A href ="#4.11 "> 4.11</ A > ) What is an R-tree index?< BR >
113113< A href ="#4.12 "> 4.12</ A > ) What is the Genetic Query Optimizer?< BR >
114- < A href ="#4.13 "> 4.13</ A > ) How do I perform regular expression searches
115- and case-insensitive regular expression searches?< BR >
114+ < A href ="#4.13 "> 4.13</ A > ) How do I perform regular expression
115+ searches and case-insensitive regular expression searches?< BR >
116116< A href ="#4.14 "> 4.14</ A > ) In a query, how do I detect if a field
117117 is< SMALL > NULL</ SMALL > ?< BR >
118118< A href ="#4.15 "> 4.15</ A > ) What is the difference between the
@@ -198,8 +198,9 @@ <H4><A name="1.2">1.2</A>) What's the copyright on PostgreSQL?</H4>
198198
199199< P > PostgreSQL Data Base Management System</ P >
200200
201- < P > Portions copyright (c) 1996-2001, PostgreSQL Global Development Group Portions
202- Copyright (c) 1994-6 Regents of the University of California</ P >
201+ < P > Portions copyright (c) 1996-2001, PostgreSQL Global Development
202+ Group Portions Copyright (c) 1994-6 Regents of the University of
203+ California</ P >
203204
204205< P > Permission to use, copy, modify, and distribute this software
205206 and its documentation for any purpose, without fee, and without a
@@ -499,8 +500,8 @@ <H4><A name="2.1">2.1</A>) Are there <SMALL>ODBC</SMALL> drivers
499500 "mailto:postgres95@openlink.co.uk "> postgres95@openlink.co.uk</ A > .</ P >
500501
501502< P > See also the< A href =
502- "http://www.PostgreSQL.org/users-lounge/docs/programmer/odbc.htm "> ODBC chapter
503- of the Programmer's Guide</ A > .</ P >
503+ "http://www.PostgreSQL.org/users-lounge/docs/programmer/odbc.htm "> ODBC
504+ chapter of the Programmer's Guide</ A > .</ P >
504505
505506< H4 > < A name ="2.2 "> 2.2</ A > ) What tools are available for using
506507 PostgreSQL with Web pages?</ H4 >
@@ -839,16 +840,16 @@ <H4><A name="4.6">4.6</A>) What is the maximum size for a row,
839840Maximum number of indexes on a table? unlimited
840841</ PRE >
841842 Of course, these are not actually unlimited, but limited to
842- available disk space and memory/swap space.
843- suffer when these values get unusually large.
843+ available disk space and memory/swap space. Performance may suffer
844+ when these values get unusually large.
844845
845846< P > The maximum table size of 16TB does not require large file
846- support from the operating system.
847- as multiple 1GB files.
848-
847+ support from the operating system. Large tables are stored as
848+ multiple 1GB files.</ P >
849+
849850< P > The maximum table size and maximum number of columns can be
850851 increased by a factor of four if the default block size is
851- increased to 32k.
852+ increased to 32k.</ P >
852853
853854< H4 > < A name ="4.7 "> 4.7</ A > ) How much database disk space is required
854855 to store data from a typical text file?< BR >
@@ -883,8 +884,8 @@ <H4><A name="4.7">4.7</A>) How much database disk space is required
883884< P > Indexes do not require as much overhead, but do contain the data
884885 that is being indexed, so they can be large also.</ P >
885886
886- < H4 > < A name ="4.8 "> 4.8</ A > ) How do I find out what tables or
887- indexes are defined in the database?</ H4 >
887+ < H4 > < A name ="4.8 "> 4.8</ A > ) How do I find out what tables or indexes
888+ are defined in the database?</ H4 >
888889
889890< P > < I > psql</ I > has a variety of backslash commands to show such
890891 information. Use \? to see them.</ P >
@@ -966,8 +967,8 @@ <H4><A name="4.13">4.13</A>) How do I perform regular expression
966967
967968< P > The< I > ~</ I > operator does regular expression matching, and
968969< I > ~*</ I > does case-insensitive regular expression matching. The
969- case-insensitive variant of< SMALL > LIKE</ SMALL >
970- is called < SMALL > ILIKE</ SMALL > .</ P >
970+ case-insensitive variant of< SMALL > LIKE</ SMALL > is called
971+ < SMALL > ILIKE</ SMALL > .</ P >
971972
972973< H4 > < A name ="4.14 "> 4.14</ A > ) In a query, how do I detect if a field
973974 is< SMALL > NULL</ SMALL > ?</ H4 >
@@ -1223,13 +1224,14 @@ <H4><A name="4.24">4.24</A>) How do I perform an outer join?<BR>
12231224 SELECT *
12241225 FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);
12251226</ PRE >
1226- or
1227+ or
12271228< PRE >
12281229 SELECT *
12291230 FROM t1 LEFT OUTER JOIN t2 USING (col);
12301231</ PRE >
1231- These identical queries join t1.col to t2.col, and also return any
1232- unjoined rows in t1 (those with no match in t2). A
1232+
1233+ < P > These identical queries join t1.col to t2.col, and also return
1234+ any unjoined rows in t1 (those with no match in t2). A
12331235< SMALL > RIGHT</ SMALL > join would add unjoined rows of t2. A
12341236< SMALL > FULL</ SMALL > join would return the matched rows plus all
12351237 unjoined rows from t1 and t2. The word< SMALL > OUTER</ SMALL > is
@@ -1242,7 +1244,7 @@ <H4><A name="4.24">4.24</A>) How do I perform an outer join?<BR>
12421244 joining< I > tab1</ I > and< I > tab2,</ I > the following query does an
12431245< I > outer</ I > join of the two tables:< BR >
12441246< BR >
1245-
1247+ </ P >
12461248< PRE >
12471249 SELECT tab1.col1, tab2.col2
12481250 FROM tab1, tab2
@@ -1296,3 +1298,4 @@ <H4><A name="5.5">5.5</A>) I have changed a source file. Why does
12961298 compiler compute the dependencies automatically.</ P >
12971299</ BODY >
12981300</ HTML >
1301+