Everything new in Firebird SQL since InterBase 6 Paul Vinkenoog et al. 9 December 2010, document version 1.0 — covers Firebird 2.0–2.0.6

Introduction

Reserved words and keywords

Miscellaneous language elements

Data types and subtypes

• ALTER DATABASE
• ALTER DOMAIN
• ALTER EXTERNAL FUNCTION
• ALTER PROCEDURE
• ALTER SEQUENCE
• ALTER TABLE
• ALTER TRIGGER
• COMMENT
• CREATE DATABASE
• CREATE DOMAIN
• CREATE EXCEPTION
• CREATE GENERATOR
• CREATE INDEX
• CREATE OR ALTER EXCEPTION
• CREATE OR ALTER PROCEDURE
• CREATE OR ALTER TRIGGER
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• RECREATE TRIGGER
• CREATE VIEW
• DECLARE EXTERNAL FUNCTION
• DECLARE FILTER
• DROP GENERATOR
• DROP PROCEDURE
• DROP SEQUENCE
• DROP TRIGGER
• RECREATE VIEW
• REVOKE ADMIN OPTION
• SET GENERATOR

• DELETE
• EXECUTE BLOCK
• EXECUTE PROCEDURE
• INSERT
• SELECT
• UPDATE

• RELEASE SAVEPOINT
• ROLLBACK
• SAVEPOINT
• SET TRANSACTION

• BEGIN ... BLOCKS may be empty
• BREAK
• CLOSE cursor
• DECLARE
• EXCEPTION
• EXECUTE PROCEDURE
• EXIT
• FETCH cursor
• FOR EXECUTE STATEMENT ... DO
• FOR SELECT INTO ... DO
• LEAVE
• OPEN cursor
• PLAN allowed in trigger code
• UDFs callable as void functions
• WHERE CURRENT OF valid again for view cursors

• current_connection
• CURRENT_ROLE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• CURRENT_TRANSACTION
• CURRENT_USER
• DELETING
• GDSCODE
• INSERTING
• NEW
• 'NOW'
• OLD
• ROW_COUNT
• SQLCODE
• UPDATING

• ALL
• ANY / SOME
• IN
• IS [NOT] DISTINCT FROM
• NEXT VALUE FOR
• NULL literals allowed as operands
• SOME
• || (string concatenator)

• BIT_LENGTH()
• CAST()
• CHAR_LENGTH(), CHARACTER_LENGTH()
• COALESCE()
• EXTRACT()
• GEN_ID()
• IIF()
• LOWER()
• NULLIF()
• OCTET_LENGTH()
• RDB$GET_CONTEXT()
• RDB$SET_CONTEXT()
• SUBSTRING()
• TRIM()
• UPPER()

• addDay
• addHour
• addMillisecond
• addMinute
• addMonth
• addSecond
• addWeek
• addYear
• ascii_char
• dow
• dpower
• getExactTimestamp
• i64round
• i64truncate
• log
• lower
• lpad
• ltrim
• *nullif
• *nvl
• rand
• right
• round, i64round
• rpad
• rtrim
• sdow
• srand
• sright
• string2blob
• strlen
• substr
• substrlen
• truncate, i64truncate

Appendix A: Notes

Appendix B: Document history

Appendix C: License notice

License note

The contents of this Documentation are subject to the Public Documentation License Version 1.0 (the “License”); you may only use this Documentation if you comply with the terms of this License. Copies of the License are available here or at https://www.firebirdsql.org/pdfmanual/pdl.pdf (PDF) and https://www.firebirdsql.org/manual/pdl.html (HTML).

The Original Documentation is titled Firebird 2.0 Language Reference Update.

The Initial Writers of the Original Documentation are: Paul Vinkenoog et al.

Copyright (C) 2008-2010. All Rights Reserved. Initial Writers contact: paul at vinkenoog dot nl.

Writers and Editors of included PDL-licensed material (the “et al.”) are: J. Beesley, Helen Borrie, Arno Brinkman, Frank Ingermann, Alex Peshkov, Nickolay Samofatov, Dmitry Yemanov.

Included portions are Copyright (C) 2001-2007 by their respective authors. All Rights Reserved.