emp.sql 375 B

1234567891011121314
  1. CREATE TABLE emp (
  2. name text,
  3. age int4,
  4. -- TODO: uncomment after point type gets supported
  5. --location point
  6. salary int4,
  7. manager name
  8. );
  9. INSERT INTO emp VALUES
  10. ('sharon', 25, /*(15,12),*/ 1000, 'sam'),
  11. ('sam', 30, /*(10,5),*/ 2000, 'bill'),
  12. ('bill', 20, /*(11,10),*/ 1000, 'sharon');