List of tables

• customer the section called Table: customer

• inventory the section called Table: inventory

List of views

• custview the section called View: custview

• invenview the section called View: invenview

List of functions

• getid(text) the section called Function: getid(text)

Table: customer

COMMENT ON TABLE customer IS 'Write comment here'

Table: inventory

COMMENT ON TABLE inventory IS 'Write comment here'

View: custview

COMMENT ON VIEW custview IS 'Write comment here'

CREATE VIEW custview AS 'SELECT * FROM customer WHERE name=''John'''

View: invenview

COMMENT ON VIEW invenview IS 'Write comment here'

CREATE VIEW invenview AS 'SELECT * FROM inventory WHERE name=''Chair'''

Function: getid(text)

COMMENT ON FUNCTION getid(text) IS 'Write comment here'

CREATE FUNCTION getid(text) RETURNS INT4 AS '
  DECLARE
    p_name ALIAS FOR $1;
    id INT4;
  BEGIN
    SELECT custid INTO id FROM customer WHERE name=p_name;
    IF NOT FOUND THEN
      RETURN 0;
    END IF;
    RETURN id;
  END;
' LANGUAGE 'PGplSQL';