Chapter 4. SQL Syntax
Table of Contents
- 4.1. Lexical Structure
- 4.2. Value Expressions
- 4.2.1. Column References
- 4.2.2. Positional Parameters
- 4.2.3. Subscripts
- 4.2.4. Field Selection
- 4.2.5. Operator Invocations
- 4.2.6. Function Calls
- 4.2.7. Aggregate Expressions
- 4.2.8. Window Function Calls
- 4.2.9. Type Casts
- 4.2.10. Collation Expressions
- 4.2.11. Scalar Subqueries
- 4.2.12. Array Constructors
- 4.2.13. Row Constructors
- 4.2.14. Expression Evaluation Rules
- 4.2.2. Positional Parameters
- 4.2.1. Column References
- 4.3. Calling Functions
This chapter describes the syntax of SQL. It forms the foundation for understanding the following chapters which will go into detail about how SQL commands are applied to define and modify data.
We also advise users who are already familiar with SQL to read this chapter carefully because it contains several rules and concepts that are implemented inconsistently among SQL databases or that are specific to PostgreSQL.