|
14 | 14 | alink="#0000ff"> |
15 | 15 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
16 | 16 |
|
17 | | -<P>Last updated: Thu Jul 11 12:35:53 EDT 2002</P> |
| 17 | +<P>Last updated: Thu Jul 11 12:37:48 EDT 2002</P> |
18 | 18 |
|
19 | 19 | <P>Current maintainer: Bruce Momjian (<Ahref= |
20 | 20 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> |
@@ -1021,7 +1021,7 @@ <H4><A name="4.12">4.12</A>) How do I perform regular expression |
1021 | 1021 | <P>The<I>~</I> operator does regular expression matching, and |
1022 | 1022 | <I>~*</I> does case-insensitive regular expression matching. The |
1023 | 1023 | case-insensitive variant of<SMALL>LIKE</SMALL> is called |
1024 | | -<SMALL>ILIKE</SMALL> in PostgreSQL 7.1 and later.</P> |
| 1024 | +<SMALL>ILIKE</SMALL>.</P> |
1025 | 1025 |
|
1026 | 1026 | <P>Case-insensitive equality comparisons are normally expressed |
1027 | 1027 | as:</P> |
@@ -1229,10 +1229,9 @@ <H4><A name="4.17">4.17</A>) What is the meaning of some of the |
1229 | 1229 | <H4><Aname="4.18">4.18</A>) Why do I get the error<I>"ERROR: |
1230 | 1230 | Memory exhausted in AllocSetAlloc()"</I>?</H4> |
1231 | 1231 |
|
1232 | | -<P>If you are running a version older than 7.1, an upgrade may fix |
1233 | | - the problem. Also it is possible you have run out of virtual memory |
1234 | | - on your system, or your kernel has a low limit for certain |
1235 | | - resources. Try this before starting<I>postmaster</I>:</P> |
| 1232 | +<P>You probably have run out of virtual memory on your system, |
| 1233 | + or your kernel has a low limit for certain resources. Try this |
| 1234 | + before starting<I>postmaster</I>:</P> |
1236 | 1235 | <PRE> |
1237 | 1236 | ulimit -d 262144 |
1238 | 1237 | limit datasize 256m |
@@ -1301,8 +1300,8 @@ <H4><A name="4.22">4.22</A>) Why are my subqueries using |
1301 | 1300 |
|
1302 | 1301 | <H4><Aname="4.23">4.23</A>) How do I perform an outer join?</H4> |
1303 | 1302 |
|
1304 | | -<P>PostgreSQL7.1 and latersupports outer joins using the SQL |
1305 | | -standard syntax.Here are two examples:</P> |
| 1303 | +<P>PostgreSQL supports outer joins using the SQL standard syntax. |
| 1304 | + Here are two examples:</P> |
1306 | 1305 | <PRE> |
1307 | 1306 | SELECT * |
1308 | 1307 | FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col); |
|