Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f17Dejx50938 for ; Wed, 7 Feb 2001 08:40:45 -0500 (EST) (envelope-from pgsql-docs-owner@postgresql.org) Received: from monet.jollygreen.com (monet.jollygreen.com [63.114.138.105]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16NnOx56024 for ; Tue, 6 Feb 2001 18:49:25 -0500 (EST) (envelope-from keith@jollygreen.com) Received: from [63.114.138.100] (bloody.jollygreen.com [63.114.138.100]) by monet.jollygreen.com (8.9.3/8.9.3) with ESMTP id PAA09990 for ; Tue, 6 Feb 2001 15:49:20 -0800 Mime-Version: 1.0 X-Sender: keith@mail.jollygreen.com Message-Id: Date: Tue, 6 Feb 2001 15:49:02 -0800 To: pgsql-docs@postgresql.org From: Keith Anderson Subject: FAQ misinformation Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Archive-Number: 200102/6 X-Sequence-Number: 259 In your FAQ on at 'http://www.postgresql.org/docs/faq-english.html', Question 4.13 refers to the ILIKE operator, which does NOT exist in any current versions of PostgreSQL. According to the mailing list archives, it is slated for inclusion in the 7.1 release - but to include it in the FAQ before then is misleading (I just spent an hour trying to get it to work!). ----- Quote from the web page ----- 4.13) How do I perform regular expression searches and case-insensitive regular expression searches? The ~ operator does regular expression matching, and ~* does case-insensitive regular expression matching. The case-insensitive variant of LIKE is called ILIKE. ----- End Quote ----- Thanks, Keith PS - LOVE the software. Been using it since 95! Keep up the good work. ======================================================== == GIANT Network Productions == == web hosting + web design + consulting == ======================================================== ++ 541 . 684 . 9798 http://www.jollygreen.com/ ++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++