aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial
diff options
context:
space:
mode:
Diffstat (limited to 'src/tutorial')
-rw-r--r--src/tutorial/complex.source2
-rw-r--r--src/tutorial/syscat.source24
2 files changed, 6 insertions, 20 deletions
diff --git a/src/tutorial/complex.source b/src/tutorial/complex.source
index 03559267016..d849ec0d4b7 100644
--- a/src/tutorial/complex.source
+++ b/src/tutorial/complex.source
@@ -111,7 +111,7 @@ CREATE FUNCTION complex_add(complex, complex)
LANGUAGE C IMMUTABLE STRICT;
-- we can now define the operator. We show a binary operator here but you
--- can also define unary operators by omitting either of leftarg or rightarg.
+-- can also define a prefix operator by omitting the leftarg.
CREATE OPERATOR + (
leftarg = complex,
rightarg = complex,
diff --git a/src/tutorial/syscat.source b/src/tutorial/syscat.source
index 3a1767f97be..8a04d6a961f 100644
--- a/src/tutorial/syscat.source
+++ b/src/tutorial/syscat.source
@@ -96,36 +96,22 @@ SELECT n.nspname, r.rolname, format_type(t.oid, null) as typname
--
--- lists all left unary operators
+-- lists all prefix operators
--
-SELECT n.nspname, o.oprname AS left_unary,
+SELECT n.nspname, o.oprname AS prefix_op,
format_type(right_type.oid, null) AS operand,
format_type(result.oid, null) AS return_type
FROM pg_namespace n, pg_operator o,
pg_type right_type, pg_type result
WHERE o.oprnamespace = n.oid
- and o.oprkind = 'l' -- left unary
+ and o.oprkind = 'l' -- prefix ("left unary")
and o.oprright = right_type.oid
and o.oprresult = result.oid
ORDER BY nspname, operand;
--
--- lists all right unary operators
---
-SELECT n.nspname, o.oprname AS right_unary,
- format_type(left_type.oid, null) AS operand,
- format_type(result.oid, null) AS return_type
- FROM pg_namespace n, pg_operator o,
- pg_type left_type, pg_type result
- WHERE o.oprnamespace = n.oid
- and o.oprkind = 'r' -- right unary
- and o.oprleft = left_type.oid
- and o.oprresult = result.oid
- ORDER BY nspname, operand;
-
---
--- lists all binary operators
+-- lists all infix operators
--
SELECT n.nspname, o.oprname AS binary_op,
format_type(left_type.oid, null) AS left_opr,
@@ -134,7 +120,7 @@ SELECT n.nspname, o.oprname AS binary_op,
FROM pg_namespace n, pg_operator o, pg_type left_type,
pg_type right_type, pg_type result
WHERE o.oprnamespace = n.oid
- and o.oprkind = 'b' -- binary
+ and o.oprkind = 'b' -- infix ("binary")
and o.oprleft = left_type.oid
and o.oprright = right_type.oid
and o.oprresult = result.oid