我在
Postgres有一个查询：
SELECT DISTINCT a.profn FROM tprof a,sap_tstc b,tgrc c WHERE ((c.grcid ~~ a.grcid) AND ((c.tcode) = (b.tcode)));
什么是~~是什么意思？
从
9.7.1. LIKE的Postgresql文档：
The operator
~~is equivalent toLIKE,and~~*corresponds toILIKE. There are also!~~and!~~*operators that representNOT LIKEandNOT ILIKE,respectively. All of these operators are Postgresql-specific.
