Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF230476061 for ; Mon, 19 Aug 2002 16:43:22 -0400 (EDT) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id CD93647605C for ; Mon, 19 Aug 2002 16:43:21 -0400 (EDT) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.9) with ESMTP-TLS id 1290450 for pgsql-docs@postgresql.org; Mon, 19 Aug 2002 13:31:27 -0700 Message-ID: <3D61583B.6000608@joeconway.com> Date: Mon, 19 Aug 2002 13:42:35 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0) Gecko/20020530 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: functions-matching correct? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/12 X-Sequence-Number: 1430 7.2.1 docs: http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-LIKE " It's also possible to select no escape character by writing ESCAPE ''. In this case there is no way to turn off the special meaning of underscore and percent signs in the pattern." 7.3 development docs: http://developer.postgresql.org/docs/postgres/functions-matching.html#FUNCTIONS-LIKE " It's also possible to select no escape character by writing ESCAPE ''. This effectively disables the escape mechanism and turns off the special meaning of underscore and percent signs in the pattern." I think the former is still correct, isn't it? Joe