summaryrefslogtreecommitdiff
path: root/src/tutorial/advanced.source
diff options
context:
space:
mode:
Diffstat (limited to 'src/tutorial/advanced.source')
-rw-r--r--src/tutorial/advanced.source60
1 files changed, 0 insertions, 60 deletions
diff --git a/src/tutorial/advanced.source b/src/tutorial/advanced.source
deleted file mode 100644
index 7dd3ab1bb40..00000000000
--- a/src/tutorial/advanced.source
+++ /dev/null
@@ -1,60 +0,0 @@
----------------------------------------------------------------------------
---
--- advanced.sql-
--- Tutorial on advanced more PostgreSQL features
---
---
--- Copyright (c) 1994, Regents of the University of California
---
--- $Id: advanced.source,v 1.5 2002/04/11 21:18:50 tgl Exp $
---
----------------------------------------------------------------------------
-
------------------------------
--- Inheritance:
--- A table can inherit from zero or more tables. A query can reference
--- either all rows of a table or all rows of a table plus all of its
--- descendants.
------------------------------
-
--- For example, the capitals table inherits from cities table. (It inherits
--- all data fields from cities.)
-
-CREATE TABLE cities (
- name text,
- population float8,
- altitude int -- (in ft)
-);
-
-CREATE TABLE capitals (
- state char(2)
-) INHERITS (cities);
-
--- Now, let's populate the tables.
-INSERT INTO cities VALUES ('San Francisco', 7.24E+5, 63);
-INSERT INTO cities VALUES ('Las Vegas', 2.583E+5, 2174);
-INSERT INTO cities VALUES ('Mariposa', 1200, 1953);
-
-INSERT INTO capitals VALUES ('Sacramento', 3.694E+5, 30, 'CA');
-INSERT INTO capitals VALUES ('Madison', 1.913E+5, 845, 'WI');
-
-SELECT * FROM cities;
-SELECT * FROM capitals;
-
--- You can find all cities, including capitals, that
--- are located at an altitude of 500 ft or higher by:
-
-SELECT c.name, c.altitude
-FROM cities c
-WHERE c.altitude > 500;
-
--- To scan rows of the parent table only, use ONLY:
-
-SELECT name, altitude
-FROM ONLY cities
-WHERE altitude > 500;
-
-
--- clean up (you must remove the children first)
-DROP TABLE capitals;
-DROP TABLE cities;