Firebird Documentation Index → Firebird 1.5 Language Ref. Update
Firebird Home Firebird Home Firebird Documentation IndexNext: Introduction

Firebird 1.5 Language Reference Update

Everything new in Firebird SQL since InterBase 6

Paul Vinkenoog et al.

8 December 2010, document version 1.1 — covers Firebird 1.0–1.5.6


Table of Contents

1. Introduction
Versions covered
Authorship
2. Reserved words
Added in 1.0 but removed in 1.5
Added in 1.0 and 1.5
To be added in future versions
3. Miscellaneous language elements
-- (single-line comment)
|| (string concatenator)
Shorthand casts
CASE construct
4. Data types and subtypes
BIGINT data type
New character sets
Character set NONE handling changed
New collations
5. DDL statements
ALTER DOMAIN
ALTER TABLE
ALTER TRIGGER
CREATE DATABASE
CREATE DOMAIN
CREATE GENERATOR
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE OR ALTER PROCEDURE
CREATE OR ALTER TRIGGER
DECLARE EXTERNAL FUNCTION
DROP GENERATOR
DROP TRIGGER
RECREATE PROCEDURE
RECREATE TABLE
RECREATE VIEW
6. DML statements
EXECUTE PROCEDURE
SELECT
7. Transaction control statements
RELEASE SAVEPOINT
ROLLBACK TO SAVEPOINT
SAVEPOINT
8. PSQL statements
BEGIN ... END blocks may be empty
BREAK
DECLARE [VARIABLE] with initialization
EXCEPTION
EXECUTE PROCEDURE
EXECUTE STATEMENT
EXIT
FOR EXECUTE STATEMENT ... DO
FOR SELECT ... INTO ... DO
LEAVE
PLAN allowed in trigger code
9. Context variables
CURRENT_CONNECTION
CURRENT_ROLE
CURRENT_TRANSACTION
CURRENT_USER
DELETING
GDSCODE
INSERTING
ROW_COUNT
SQLCODE
UPDATING
10. Internal functions
COALESCE()
EXTRACT()
NULLIF()
SUBSTRING()
11. External functions (UDFs)
addDay
addHour
addMilliSecond
addMinute
addMonth
addSecond
addWeek
addYear
ascii_char
dow
dpower
getExactTimestamp
i64round
i64truncate
log
lpad
ltrim
*nullif
*nvl
right
round, i64round
rpad
rtrim
sdow
sright
string2blob
substr
substrlen
truncate, i64truncate
A. Notes
Character set NONE data accepted “as is
Understanding the WITH LOCK clause
A note on CSTRING parameters
B. Document History
C. License notice

List of Tables

4.1. Character sets new in Firebird
4.2. Collations new in Firebird
5.1. Maximum indices per table
10.1. Ranges for EXTRACT results
A.1. How TPB settings affect explicit locking
Firebird Documentation IndexNext: Introduction
Firebird Documentation Index → Firebird 1.5 Language Ref. Update