Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
February 20, 2025:
PostgreSQL 17.4, 16.8, 15.12, 14.17, and 13.20 Released!
Documentation
→
PostgreSQL 9.1
Supported Versions:
Current
(
17
) /
16
/
15
/
14
/
13
Development Versions:
devel
Unsupported versions:
12
/
11
/
10
/
9.6
/
9.5
/
9.4
/
9.3
/
9.2
/
9.1
/
9.0
/
8.4
/
8.3
/
8.2
/
8.1
/
8.0
/
7.4
/
7.3
/
7.2
/
7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
PostgreSQL 9.1.24 Documentation
Prev
Up
Next
Chapter 4. SQL Syntax
Table of Contents
4.1.
Lexical Structure
4.1.1.
Identifiers and Key Words
4.1.2.
Constants
4.1.3.
Operators
4.1.4.
Special Characters
4.1.5.
Comments
4.1.6.
Operator Precedence
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.