1 files changed, 13 insertions, 0 deletions
diff --git a/test/dialect/postgresql/test_compiler.py b/test/dialect/postgresql/test_compiler.py
index 708dbe147..517d570c9 100644
--- a/test/dialect/postgresql/test_compiler.py
+++ b/test/dialect/postgresql/test_compiler.py
@@ -452,7 +452,20 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
             dialect=postgresql.dialect(),
         )
 
+        idx3 = Index(
+            "test_idx2",
+            tbl.c.data,
+            postgresql_where="data > 'a' AND data < 'b''s'",
+        )
+        self.assert_compile(
+            schema.CreateIndex(idx3),
+            "CREATE INDEX test_idx2 ON testtbl (data) "
+            "WHERE data > 'a' AND data < 'b''s'",
+            dialect=postgresql.dialect(),
+        )
+
     def test_create_index_with_ops(self):
+
         m = MetaData()
         tbl = Table(
             "testtbl",