aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/syscat.source
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2010-11-23 22:27:50 +0200
committerPeter Eisentraut <peter_e@gmx.net>2010-11-23 22:34:55 +0200
commitfc946c39aeacdff7df60c83fca6582985e8546c8 (patch)
tree866145f64c09c0673a4aa3d3a2f5647f0b7afc45 /src/tutorial/syscat.source
parent44475e782f4674d257b9e5c1a3930218a4b4deea (diff)
downloadpostgresql-fc946c39aeacdff7df60c83fca6582985e8546c8.tar.gz
postgresql-fc946c39aeacdff7df60c83fca6582985e8546c8.zip
Remove useless whitespace at end of lines
Diffstat (limited to 'src/tutorial/syscat.source')
-rw-r--r--src/tutorial/syscat.source24
1 files changed, 12 insertions, 12 deletions
diff --git a/src/tutorial/syscat.source b/src/tutorial/syscat.source
index ad50d10fd40..10edf62e169 100644
--- a/src/tutorial/syscat.source
+++ b/src/tutorial/syscat.source
@@ -42,8 +42,8 @@ SELECT n.nspname, c.relname
-- column reference)
--
SELECT n.nspname AS schema_name,
- bc.relname AS class_name,
- ic.relname AS index_name,
+ bc.relname AS class_name,
+ ic.relname AS index_name,
a.attname
FROM pg_namespace n,
pg_class bc, -- base class
@@ -64,7 +64,7 @@ SELECT n.nspname AS schema_name,
-- classes
--
SELECT n.nspname, c.relname, a.attname, format_type(t.oid, null) as typname
- FROM pg_namespace n, pg_class c,
+ FROM pg_namespace n, pg_class c,
pg_attribute a, pg_type t
WHERE n.oid = c.relnamespace
and c.relkind = 'r' -- no indices
@@ -94,10 +94,10 @@ SELECT n.nspname, r.rolname, format_type(t.oid, null) as typname
--
-- lists all left unary operators
--
-SELECT n.nspname, o.oprname AS left_unary,
+SELECT n.nspname, o.oprname AS left_unary,
format_type(right_type.oid, null) AS operand,
format_type(result.oid, null) AS return_type
- FROM pg_namespace n, pg_operator o,
+ 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
@@ -109,10 +109,10 @@ SELECT n.nspname, o.oprname AS left_unary,
--
-- lists all right unary operators
--
-SELECT n.nspname, o.oprname AS right_unary,
+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,
+ 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
@@ -127,7 +127,7 @@ SELECT n.nspname, o.oprname AS binary_op,
format_type(left_type.oid, null) AS left_opr,
format_type(right_type.oid, null) AS right_opr,
format_type(result.oid, null) AS return_type
- FROM pg_namespace n, pg_operator o, pg_type left_type,
+ 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
@@ -142,12 +142,12 @@ SELECT n.nspname, o.oprname AS binary_op,
-- C functions
--
SELECT n.nspname, p.proname, p.pronargs, format_type(t.oid, null) as return_type
- FROM pg_namespace n, pg_proc p,
+ FROM pg_namespace n, pg_proc p,
pg_language l, pg_type t
WHERE p.pronamespace = n.oid
and n.nspname not like 'pg\\_%' -- no catalogs
and n.nspname != 'information_schema' -- no information_schema
- and p.prolang = l.oid
+ and p.prolang = l.oid
and p.prorettype = t.oid
and l.lanname = 'c'
ORDER BY nspname, proname, pronargs, return_type;
@@ -156,7 +156,7 @@ SELECT n.nspname, p.proname, p.pronargs, format_type(t.oid, null) as return_type
-- lists all aggregate functions and the types to which they can be applied
--
SELECT n.nspname, p.proname, format_type(t.oid, null) as typname
- FROM pg_namespace n, pg_aggregate a,
+ FROM pg_namespace n, pg_aggregate a,
pg_proc p, pg_type t
WHERE p.pronamespace = n.oid
and a.aggfnoid = p.oid
@@ -170,7 +170,7 @@ SELECT n.nspname, p.proname, format_type(t.oid, null) as typname
-- families
--
SELECT am.amname, n.nspname, opf.opfname, opr.oprname
- FROM pg_namespace n, pg_am am, pg_opfamily opf,
+ FROM pg_namespace n, pg_am am, pg_opfamily opf,
pg_amop amop, pg_operator opr
WHERE opf.opfnamespace = n.oid
and opf.opfmethod = am.oid