PostgresSQL Procedures

This editor formats code poorly.  Please see the linked file: create_function_2.sql

You will complete the procedure: proc_insertGame beginning on line 120.

Test your code, save it, and upload the SQL script.

Homework

Start with this file and complete the procedure: proc_insertGame

    

    Write the code to call the procedure and test it.  You may change

    the table definition if you have a good reason… document it!

    

    Document your error codes.

    

    Place all of the code in one SQL file and submit via Canvas.  Remember

    that I’m fussy about format!  This is *not* the obfuscated C contest!

    

    The prcedure proc_insertGame begins about line 118.

Tags: No tags