Introduction

System Catalog Tables

Data Types

In This Chapter

Summary of Data Types

Description of Data Types

BIGINT (XPS)

BLOB (IDS)

BOOLEAN (IDS)

BYTE

CHAR(n)

CHARACTER(n)

CHARACTER VARYING(m,r)

CLOB (IDS)

DATE

DATETIME

DEC

DECIMAL

Distinct (IDS)

DOUBLE PRECISION

FLOAT(n)

INT

INT8

INTEGER

INTERVAL

LIST(e) (IDS)

LVARCHAR(m) (IDS)

MONEY(p,s)

MULTISET(e) (IDS)

Named ROW

NCHAR(n)

NUMERIC(p,s)

NVARCHAR(m,r)

Opaque (IDS)

REAL

ROW, Named (IDS)

ROW, Unnamed (IDS)

SERIAL(n)

SERIAL8(n)

SET(e) (IDS)

SMALLFLOAT

SMALLINT

TEXT

Unnamed ROW

VARCHAR(m,r)

Built-In Data Types

Extended Data Types (IDS)

Data Type Casting and Conversion

Operator Precedence

Environment Variables

Appendix A. The stores_demo Database

Appendix B. The sales_demo and superstores_demo Databases

Appendix C. Accessibility

Glossary

Notices

Index