diff options
| -rw-r--r-- | doc/FAQ | 15 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 15 |
2 files changed, 14 insertions, 16 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Thu Jul 11 12:35:53 EDT 2002 + Last updated: Thu Jul 11 12:37:48 EDT 2002 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -803,7 +803,7 @@ The ~ operator does regular expression matching, and ~* does case-insensitive regular expression matching. The case-insensitive - variant of LIKE is called ILIKE in PostgreSQL 7.1 and later. + variant of LIKE is called ILIKE. Case-insensitive equality comparisons are normally expressed as: SELECT * @@ -956,10 +956,9 @@ BYTEA bytea variable-length byte array (null-byte safe) 4.18) Why do I get the error "ERROR: Memory exhausted in AllocSetAlloc()"? - If you are running a version older than 7.1, an upgrade may fix the - problem. Also it is possible you have run out of virtual memory on - your system, or your kernel has a low limit for certain resources. Try - this before starting postmaster: + You probably have run out of virtual memory on your system, or your + kernel has a low limit for certain resources. Try this before starting + postmaster: ulimit -d 262144 limit datasize 256m @@ -1012,8 +1011,8 @@ SELECT * 4.23) How do I perform an outer join? - PostgreSQL 7.1 and later supports outer joins using the SQL standard - syntax. Here are two examples: + PostgreSQL supports outer joins using the SQL standard syntax. Here + are two examples: SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col); diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index f14c7330361..9343a586853 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Thu Jul 11 12:35:53 EDT 2002</P> + <P>Last updated: Thu Jul 11 12:37:48 EDT 2002</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -1021,7 +1021,7 @@ <P>The <I>~</I> operator does regular expression matching, and <I>~*</I> does case-insensitive regular expression matching. The case-insensitive variant of <SMALL>LIKE</SMALL> is called - <SMALL>ILIKE</SMALL> in PostgreSQL 7.1 and later.</P> + <SMALL>ILIKE</SMALL>.</P> <P>Case-insensitive equality comparisons are normally expressed as:</P> @@ -1229,10 +1229,9 @@ BYTEA bytea variable-length byte array (null-byte safe) <H4><A name="4.18">4.18</A>) Why do I get the error <I>"ERROR: Memory exhausted in AllocSetAlloc()"</I>?</H4> - <P>If you are running a version older than 7.1, an upgrade may fix - the problem. Also it is possible you have run out of virtual memory - on your system, or your kernel has a low limit for certain - resources. Try this before starting <I>postmaster</I>:</P> + <P>You probably have run out of virtual memory on your system, + or your kernel has a low limit for certain resources. Try this + before starting <I>postmaster</I>:</P> <PRE> ulimit -d 262144 limit datasize 256m @@ -1301,8 +1300,8 @@ BYTEA bytea variable-length byte array (null-byte safe) <H4><A name="4.23">4.23</A>) How do I perform an outer join?</H4> - <P>PostgreSQL 7.1 and later supports outer joins using the SQL - standard syntax. Here are two examples:</P> + <P>PostgreSQL supports outer joins using the SQL standard syntax. + Here are two examples:</P> <PRE> SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col); |