From 6f5b8beb64d481c28a483090d10099c8d619c797 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 10 Apr 2013 13:30:14 -0400 Subject: Make contrib/pg_trgm also support regex searches with GiST indexes. This wasn't addressed in the original patch, but it doesn't take very much additional code to cover the case, so let's get it done. Since pg_trgm 1.1 hasn't been released yet, I just changed the definition of what's in it, rather than inventing a 1.2. --- doc/src/sgml/pgtrgm.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/pgtrgm.sgml b/doc/src/sgml/pgtrgm.sgml index 4572750f4d7..9039f03e8b9 100644 --- a/doc/src/sgml/pgtrgm.sgml +++ b/doc/src/sgml/pgtrgm.sgml @@ -216,8 +216,8 @@ SELECT * FROM test_trgm WHERE t LIKE '%foo%bar'; - Beginning in PostgreSQL 9.3, pg_trgm - GIN indexes also support index searches for regular-expression matches + Beginning in PostgreSQL 9.3, these index types also support + index searches for regular-expression matches (~ and ~* operators), for example SELECT * FROM test_trgm WHERE t ~ '(foo|bar)'; -- cgit v1.2.3