Date: Fri, 26 Jan 2018 08:28:35 -0500
From: Bruce Momjian <bruce@momjian.us>
To: bgailer@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: clarify Regular Expression Match Operators
Message-ID: <20180126132835.GG20836@momjian.us>
References: <20180113145906.1408.37345@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20180113145906.1408.37345@wrigleys.postgresql.org>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

On Sat, Jan 13, 2018 at 02:59:06PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/static/functions-matching.html
> Description:
> 
> Table 9.14 Regular Expression Match Operators
> It is not clear (to me)where I would put one of these operators. The Example
> column does not make sense to me.

Uh, you can use those regular expressions any place you would use an
operator:

	SELECT 'thomas' ~ '.*thomas.*';
	 ?column?
	----------
	 t

or in a where clause, e.g. WHERE col ~ 'ab.*c'.  Not sure how we can
improve the docs here.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +