title: SERIAL fields / Auto increment
body: <p>The task indicated this:</p>
  <p>Create a table named automagic with the following fields:</p>
  <p>An id field is an auto-incrementing serial field.
  A name field that allows up to 32 characters but no more This field is required.
  A height field is a floating-point number that is required.
  And my code was:</p>
  <pre><code>CREATE TABLE automatic (
      id SERIAL PRIMARY KEY NOT NULL, 
      name CHAR (32), 
      height numeric);
  </code></pre>
  <p>However, the self-rater answered this Expecting an INSERT without a height to fail, it did not fail.</p>
  <p>After that, I tried this</p>
  <pre><code>CREATE TABLE automatic (
      id int not null auto_increment primary key, 
      name varchar(32) not null, 
      height float not null);
  </code></pre>
  <p>And got</p>
  <blockquote>
  <p>ERROR:  syntax error at or near &quot;auto_increment&quot;<br />
  LINE 1: CREATE TABLE automagic (id int not null auto_increment prima...\</p>
  <p>SQL state: 42601<br />
  Character: 41</p>
  </blockquote>