summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2000-08-12 05:15:24 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2000-08-12 05:15:24 +0000
commit766fb7f707f9527be219353f5f970aab3d786554 (patch)
treeddce48601ff21cdd9a27343475779530fa0cb502 /doc/src
parent134fdf34d6c48e6420f7592a6b1e02adcf0f2d02 (diff)
Mop-up for removal of ':' and ';' operators ... like, say, actually
take 'em out of pg_operator. Also remove from scan.l's set of legal operator characters. Update documentation.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/oper.sgml63
-rw-r--r--doc/src/sgml/ref/create_operator.sgml10
2 files changed, 13 insertions, 60 deletions
diff --git a/doc/src/sgml/oper.sgml b/doc/src/sgml/oper.sgml
index aa42407bbda..e51deef0a9d 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.16 2000/05/02 20:01:52 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/Attic/oper.sgml,v 1.17 2000/08/12 05:15:24 tgl Exp $
-->
<Chapter Id="operators">
@@ -83,20 +83,10 @@ Operator Ordering (decreasing precedence)
<tbody>
<row>
<entry>
-UNION
-</entry>
-<entry>
-left
-</entry>
-<entry>
-SQL select construct
-</entry>
-</row>
-<row>
-<entry>
::
</entry>
<entry>
+left
</entry>
<entry>
<productname>Postgres</productname> typecasting
@@ -135,40 +125,26 @@ right
unary minus
</entry>
</row>
-<!--
-Deprecated as of v7.0
<row>
<entry>
-;
+|
</entry>
<entry>
left
</entry>
<entry>
-statement termination, logarithm
-</entry>
-</row>
--->
-<row>
-<entry>
-:
-</entry>
-<entry>
-right
-</entry>
-<entry>
-exponentiation
+start of interval
</entry>
</row>
<row>
<entry>
-|
+^
</entry>
<entry>
left
</entry>
<entry>
-start of interval
+power, exclusive or
</entry>
</row>
<row>
@@ -228,6 +204,7 @@ test for NOT NULL
(all other operators)
</entry>
<entry>
+left
</entry>
<entry>
native and user-defined
@@ -265,7 +242,7 @@ time interval overlap
</row>
<row>
<entry>
-LIKE
+LIKE ILIKE
</entry>
<entry>
</entry>
@@ -487,19 +464,6 @@ logical union
<ENTRY>4 / 2</ENTRY>
</ROW>
<ROW>
- <ENTRY> : </ENTRY>
- <ENTRY>Natural Exponentiation</ENTRY>
- <ENTRY>: 3.0</ENTRY>
- </ROW>
-<!--
-Deprecated in v7.0, esp. since ln() is available as a generic function.
- <ROW>
- <ENTRY> ; </ENTRY>
- <ENTRY>Natural Logarithm</ENTRY>
- <ENTRY>(; 5.0)</ENTRY>
- </ROW>
--->
- <ROW>
<ENTRY> @ </ENTRY>
<ENTRY>Absolute value</ENTRY>
<ENTRY>@ -5.0</ENTRY>
@@ -523,17 +487,6 @@ Deprecated in v7.0, esp. since ln() is available as a generic function.
</TGROUP>
</TABLE>
</Para>
-
- <para>
- <note>
- <para>
- Two operators, ":" and ";", are now deprecated and will be removed in
- the next release. Use the equivalent functions exp() and ln()
- instead.
- </para>
- </note>
- </para>
-
</sect1>
<sect1>
diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml
index 30cf27b3974..cf6baf7fa5e 100644
--- a/doc/src/sgml/ref/create_operator.sgml
+++ b/doc/src/sgml/ref/create_operator.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_operator.sgml,v 1.14 2000/07/21 17:58:49 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_operator.sgml,v 1.15 2000/08/12 05:15:23 tgl Exp $
Postgres documentation
-->
@@ -177,15 +177,15 @@ CREATE
is a sequence of up to NAMEDATALEN-1 (31 by default) characters
from the following list:
<literallayout>
-+ - * / &lt; &gt; = ~ ! @ # % ^ &amp; | ` ? $ :
++ - * / &lt; &gt; = ~ ! @ # % ^ &amp; | ` ? $
</literallayout>
There are a few restrictions on your choice of name:
<itemizedlist>
<listitem>
<para>
- "$" and ":" cannot be defined as single-character operators,
- although they can be part of a multi-character operator name.
+ "$" cannot be defined as a single-character operator,
+ although it can be part of a multi-character operator name.
</para>
</listitem>
<listitem>
@@ -199,7 +199,7 @@ CREATE
A multi-character operator name cannot end in "+" or "-",
unless the name also contains at least one of these characters:
<literallayout>
-~ ! @ # % ^ &amp; | ` ? $ :
+~ ! @ # % ^ &amp; | ` ? $
</literallayout>
For example, <literal>@-</literal> is an allowed operator name,
but <literal>*-</literal> is not.