diff options
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 15 |
1 files changed, 7 insertions, 8 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); |