CREATE SEQUENCE
CREATE SEQUENCE
CREATE SEQUENCE
CREATE SEQUENCE
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
CREATE TABLE
CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
BEGIN
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
COMMIT
INSERT 0 5
INSERT 0 11
INSERT 0 4
INSERT 0 5
INSERT 0 2
BEGIN
INSERT 0 4
INSERT 0 3
INSERT 0 4
COMMIT
INSERT 0 3
INSERT 0 3
INSERT 0 3
 anr 
-----
  30
  20
(2 rows)

CREATE VIEW
 lnr | preis  
-----+--------
   1 |  40.00
   2 |  65.00
   3 | 205.00
   4 | 130.00
(4 rows)

CREATE VIEW
 knr | erstelldatum |     anschrift      | sonderrabatt 
-----+--------------+--------------------+--------------
   1 | 2014-10-28   | Hauptstraße 4      |           10
   5 | 2014-12-28   | Römerweg 45a       |           15
   2 | 2015-10-10   | Patentstraße 56    |           10
   3 | 2015-08-10   | Kantorweg 67       |            5
   4 | 2015-06-07   | Linke Wulkazeile 5 |            5
(5 rows)

 f_calc_apos 
-------------
      105.30
(1 row)

DROP FUNCTION
DROP TRIGGER
DROP FUNCTION
DROP TRIGGER
DROP TRIGGER
DROP FUNCTION
DROP TRIGGER
DROP FUNCTION
DROP VIEW
DROP VIEW
ALTER TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP SEQUENCE
DROP SEQUENCE
DROP SEQUENCE
DROP SEQUENCE
DROP SEQUENCE
