SQL Dialects Reference

From Wikibooks, open books for an open world
Jump to: navigation, search
A Wikibookian suggests that Converting MySQL to PostgreSQL be merged into this book or chapter.
Discuss whether or not this merger should happen on the discussion page.

Contents

  1. Introduction
  2. Data structure definition
    1. Data types
      1. Numeric types
      2. Character types
      3. Date and time types
      4. Binary types
      5. Large object types
      6. Misc types
    2. Delimited identifiers
    3. Auto-increment column
  3. Functions and expressions
    1. Math functions
      1. Trigonometric functions
      2. Numeric functions
      3. Aggregate functions
    2. Date and time functions
    3. String functions
    4. Misc expressions
  4. Select queries
    1. Select without tables
    2. Limiting results of select query
    3. Hierarchical Queries
  5. Write queries
    1. Replace query
    2. Insert results from select query into existing table
    3. Save results from select query as new table
  6. Transactions
  7. Procedural language
    1. Stored procedures
    2. User-defined functions (UDFs)
  8. SQL XML
  9. Administration
  10. References
    75% developed
Retrieved from "http://en.wikibooks.org/w/index.php?title=SQL_Dialects_Reference&oldid=2008091"