PG 11中的“^@”运算符
👉 本文共约192个字，系统预计阅读时间或需1分钟。
所有运算符参考：https://www.xmmup.com/postgresql-yunsuanfu.html
pg11新增了^@运算符，其作用类似于like 'aa%' 如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | C:\Users\lhrxxt>psql -U postgres -h 192.168.66.35 -p 64310 Password for user postgres: psql (13.3, server 13.2 (Debian 13.2-1.pgdg100+1)) Type "help" for help. postgres=# select *from pg_user where usename like 'rep%'; usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig ---------+----------+-------------+----------+---------+--------------+----------+----------+----------- repuser | 16384 | f | f | t | f | ******** | | (1 row) postgres=# select *from pg_user where usename ^@ 'rep'; usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig ---------+----------+-------------+----------+---------+--------------+----------+----------+----------- repuser | 16384 | f | f | t | f | ******** | | (1 row) postgres=# select *from pg_user where usename ^@'rep'; usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig ---------+----------+-------------+----------+---------+--------------+----------+----------+----------- repuser | 16384 | f | f | t | f | ******** | | (1 row) |
注意点：
- ^@运算符不支持B-Tree索引，支持SP-GiST索引，
- like运算符是支持B-Tree索引的
