Firebird 1.5 Language Reference Update

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