summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--pygments/lexers/postgres.py2
-rw-r--r--tests/examplefiles/psql_session.txt2
2 files changed, 2 insertions, 2 deletions
diff --git a/pygments/lexers/postgres.py b/pygments/lexers/postgres.py
index a460d1fe..8b584811 100644
--- a/pygments/lexers/postgres.py
+++ b/pygments/lexers/postgres.py
@@ -42,7 +42,7 @@ class PostgresLexer(RegexLexer):
(r'(' + '|'.join([s.replace(" ", "\s+") for s in DATATYPES])
+ r')\b', Name.Builtin),
(r'(' + '|'.join(KEYWORDS) + r')\b', Keyword),
- (r'[+*/<>=~!@#%^&|`?^-]', Operator),
+ (r'[+*/<>=~!@#%^&|`?^-]+', Operator),
(r'::', Operator), # cast
(r'([0-9]*\.[0-9]*|[0-9]+)(e[+-]?[0-9]+)?', Number.Float),
(r'[0-9]+', Number.Integer),
diff --git a/tests/examplefiles/psql_session.txt b/tests/examplefiles/psql_session.txt
index fc39b42c..a0f045bc 100644
--- a/tests/examplefiles/psql_session.txt
+++ b/tests/examplefiles/psql_session.txt
@@ -15,7 +15,7 @@ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
(1 row)
piro=> \set foo 30;
-piro=> select * from test where foo < :foo;
+piro=> select * from test where foo <= :foo;
foo | bar
-----+-----
10 |