From c20ae1ce5024d8723c25bdd5c1feb6ca936b8e15 Mon Sep 17 00:00:00 2001
From: Bruce Momjian 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) 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.Frequently Asked Questions (FAQ) for PostgreSQL
-
@@ -1021,7 +1021,7 @@
Case-insensitive equality comparisons are normally expressed as:
@@ -1229,10 +1229,9 @@ BYTEA bytea variable-length byte array (null-byte safe)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 @@ -1301,8 +1300,8 @@ BYTEA bytea variable-length byte array (null-byte safe)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); -- cgit v1.2.3