Firebird 5.0 Language Reference

About The Firebird 5.0 Language Reference

Sql Language Structure

Data Types and Subtypes

Integer Data Types

SMALLINT

INTEGER

BIGINT

INT128

Hexadecimal Format for Integer Numbers

Floating-Point Data Types

Approximate Floating-Point Data Types

FLOAT

REAL

DOUBLE PRECISION

Decimal Floating-Point Types

DECFLOAT

Behaviour of

Length of

DECFLOAT Use with Standard Functions Special Functions for

Length of

DECFLOAT Use with Standard Functions Special Functions for

DECFLOAT Use with Standard Functions Special Functions for

Fixed-Point Data Types

NUMERIC

DECIMAL

Data Types for Dates and Times

DATE

TIME

TIME [WITHOUT TIME ZONE]

TIME WITH TIME ZONE

TIMESTAMP

TIMESTAMP [WITHOUT TIME ZONE]

TIMESTAMP WITH TIME ZONE

Session Time Zone

Time Zone Format

Operations Using Date and Time Values

Supplemental Time Zone Features

Virtual table

Package

Updating the Time Zone Database

Character Data Types

Unicode

Client Character Set

Special Character Sets

Collation

Case-Insensitive Searching

UTF8

Character Indexes

Character Types in Detail

BINARY

CHAR

VARBINARY

VARCHAR

NCHAR

Boolean Data Type

BOOLEAN

The

BOOLEAN

Use of Boolean Against Other Data Types

Binary Data Types

BLOB

BLOB

Array Types

Specifying Explicit Boundaries for Dimensions

Adding More Dimensions PSQL Source for

Special Data Types

SQL_NULL

Conversion of Data Types

Explicit Data Type Conversion

Casting to a Domain

Casting to

Conversions Possible for the

Datetime Formats

Shorthand Casts for Datetime Data Types

Implicit Data Type Conversion

Implicit Conversion During String Concatenation

Custom Data Types — Domains

Domain Attributes

Domain Override

Creating and Administering Domains

Altering a Domain

Deleting (Dropping) a Domain

Data Type Declaration Syntax

Scalar Data Types Syntax

Use of Domains in Declarations

Use of Column Type in Declarations

BLOB Data Types Syntax

Array Data Types Syntax

Common Language Elements

Data Definition (Ddl) Statements

Database

Shadow

Domain

Table

Index

View

Trigger

Procedure

Function

External Function

Package

Package Body

Filter

Sequence

Exception

Collation

Character Set

Comments

Data Manipulation (Dml) Statements

Procedural Sql (Psql) Statements

Built-In Scalar Functions

Aggregate Functions

Window (Analytical) Functions

System Packages

Context Variables

Transaction Control

Security

User Authentication

Sql Statements For User Management

Sql Privileges

Role

Statements For Granting Privileges

Statements For Revoking Privileges

Mapping Of Users To Objects

Database Encryption

Sql Security

Management Statements

Supplementary Information

Exception Codes And Messages

Reserved Words And Keywords

System Tables

Monitoring Tables

Security Tables

Plugin Tables

Character Sets And Collations

License Notice

Document History