aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2000-09-15 20:20:11 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2000-09-15 20:20:11 +0000
commite930a9a97b46113a8932feb8555a3df362056080 (patch)
treec2b9f5c691c5aa249967fbad60554b173d1d7efe
parent8d48d89dc7148be56031bd135771f173a94d3d8d (diff)
downloadpostgresql-e930a9a97b46113a8932feb8555a3df362056080.tar.gz
postgresql-e930a9a97b46113a8932feb8555a3df362056080.zip
Add ILIKE operators ~~*, !~~* to documentation.
-rw-r--r--doc/src/sgml/oper.sgml12
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/oper.sgml b/doc/src/sgml/oper.sgml
index e51deef0a9d..7f38294530c 100644
--- a/doc/src/sgml/oper.sgml
+++ b/doc/src/sgml/oper.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/Attic/oper.sgml,v 1.17 2000/08/12 05:15:24 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/Attic/oper.sgml,v 1.18 2000/09/15 20:20:11 tgl Exp $
-->
<Chapter Id="operators">
@@ -382,6 +382,16 @@ logical union
<ENTRY>'bruce' !~~ '%al%'</ENTRY>
</ROW>
<ROW>
+ <ENTRY> ~~* </ENTRY>
+ <ENTRY>ILIKE</ENTRY>
+ <ENTRY>'scrappy,marc,hermit' ~~* '%Scrappy%'</ENTRY>
+ </ROW>
+ <ROW>
+ <ENTRY> !~~* </ENTRY>
+ <ENTRY>NOT ILIKE</ENTRY>
+ <ENTRY>'Bruce' !~~* '%al%'</ENTRY>
+ </ROW>
+ <ROW>
<ENTRY> ~ </ENTRY>
<ENTRY>Match (regex), case sensitive</ENTRY>
<ENTRY>'thomas' ~ '.*thomas.*'</ENTRY>