Share-Ebooks.com

Table of Contents
1. SQL Syntax

Lexical Structure

Identifiers and Key Words
Constants
Operators and Special Characters
Comments

Lexical Precedence
Columns
Arrays
Value Expressions

Column References
Positional Parameters
Function Calls
Aggregate Expressions

Queries

Table Expressions
Select Lists
Sorting Rows
LIMIT and OFFSET
Combining Queries

Indices

Introduction to Indices
Index Types
Multi-Column Indices
Unique Indices
Functional Indices
Operator Classes
Keys
Partial Indices

Inheritance

2. Data Types

Numeric Types

The Serial Type

Monetary Type
Character Types
Date/Time Types

Date/Time Input
Date/Time Output
Date/Time Calculations

Boolean Type
Geometric Types

Point
Line Segment
Box
Path
Polygon
Circle

Network Address Data Types

inet
cidr
inet versus cidr
macaddr

Bit String Types
Large Objects (LOBs)
Type Conversion

Overview
Operators
Functions
Query Targets
UNION and CASE Constructs

3. Operators and Functions

Logical Operators
Comparison Operators
Mathematical Functions and Operators
Aggregate Functions
String Functions and Operators
Pattern Matching

Pattern Matching with LIKE
POSIX Regular Expressions

Formatting Functions
Date/Time Functions

EXTRACT
date_part
date_trunc
Current Date/Time

Geometric Functions and Operators
Network Address Type Functions
Large Object Functions
Miscellaneous Functions

To Download this E-Book Click Here.